Changing number in cell when printing
 

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.

Changing number in cell when printing
 

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


"JLee" wrote:

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.

Changing number in cell when printing
 

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

On Mon, 4 Feb 2008 07:57:00 -0800, JLee wrote:

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.