Hi all,

I have no idea where to start with this one, but I am trying to print 3 sheets in a workbook while maintaining the page numbers on the sheets. This is simple enough if I only need one of each sheet, but sometimes I'll need 2 or more copies of one sheet or another. I have been able to print the sheets using cell references to identify quantities, but I'm having trouble maintaining page numbers.

For example, if I need:

3 copies of Sheet 1
2 copies of Sheet 2
4 copies of Sheet 3

I need 9 pages total, and would need the copies of Sheet 1 to say 1 of 9, 2 of 9, 3 of 9, then Sheet 2 as 4 of 9, 5 of 9 and so on.

However, when I print, I only 1 of 3, 2 of 3, and 3 of 3 on Sheet 1, 2 and 3 respectively, before it starts again at 1 with the next round.