View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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.