Hello excelforum...

I'm working on a project right now and need some help on printing. The sheet has a total of 800 preformatted pages, each with formulas to pull up the needed information. The problem is, on a typical day only about 350 need to be printed. I created 800 for future expandability, and that number can't be changed.

The layout is 20 pages tall, 40 pages wide. Each 'section' of 20 pages needs to print only the populated pages, for example...

The first section, (which is the first 20 page tall column) needs 13 pages printed. The second section needs only 5. I need help figuring out how to tell excel to print pages 1-13, then pages 21-25, and so on until all 40 sections have been printed. The numbers '13' and '5' are in cells at the top of the sheet outside the print area, I am using a =count formula to determine how many populated pages there are.

Thanks in advance!