This is probably a function not capable of Excel, but thought I'd ask.

What I have is an Excel workbook with all our products listed, including codes, descriptions, costs, taxes, etc, and I want to print this information in a formatted way.

I have set up a single spreadsheet with the style I would like excel to print the data, and can auto import the appropriate data fields from the other spreadsheets to populate the areas I want.

However, our product database contains about 100 products, and this new printing spreadsheet i have created fits 5 products each. Now, my options are to just create page after page of tempaltes to print all of our products. Or, is it possible to have Excel continuously use the single page spreadsheet as a printing template and for every new page, just keep referencing to 5 different products every time?

Thanks, and if it sounds like I don't know what I'm talking about, your right!