Sorry for jumping in but I think I am trying to d something similar.
I have 4 tables within one sheet in one excel file which i need to print 50
times to get a total of 200 copies. I would like each table to have a
unique reference number 1,2,3,4. The cells I need to fill are S6, AS6, S59
and AS59, which will have numbers 1-4 on the first sheet printed, (one number
per
table that is), 5-9 on the second etc.
Is it possible to adapt the solution u proposed here to do that? I am
completely clueless on VBA.
Thanks