| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing copies with changing number | Excel Discussion (Misc queries) | |||
| changing the cell name when printing comments | Excel Discussion (Misc queries) | |||
| changing a cell from date to a number | Excel Worksheet Functions | |||
| CELLS HAVING SAME NUMBER BY CHANGING ANY CELL | Excel Discussion (Misc queries) | |||
| Changing number in same cell | Excel Worksheet Functions | |||
Linear Mode
