Changing number in cell when printing

[JLee]

Does anyone know if there is a way to print subsequent numbers in a cell when
printing such as:

If I was to put number 340 in cell A2 than next page it will automatically
print with number 341 in cell A2(page 2), number 343 in cell A2(page 3) etc.

 

[CLR]

You could put formulas in all your subsequent sheets, like in Sheet2A2 put
=Sheet1!a2+1, and in Sheet3A2 put =Sheet2A2+1, etc etc..........then whatever
number you put in Sheet1A2 will start the sequance.

Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

You are wanting to print multiple copies of the same page?

See Ron de Bruin's site for code.

http://www.rondebruin.nl/print.htm#every


Gord Dibben MS Excel MVP