Auto numeration in every sheet?

English
, ,
#1

I am working with information every day. I am tired several times a day copying sheet and changing numeration in every sheet.
Is there any way to create automatic numeration in every sheet ?
example: Sheet1 and starting number in cell A1 is 500. I create new sheet (sheet2) and number in cell A1 now is 501. Again i create new sheet (sheet3) and number in cell A1 now is 502 and go on.

Sorry for my bad english, but i hope u will understand what i want to know :smiley:

#2

You can get the sheet number with =SHEET() function so =ROW()+500*(SHEET()-1) should do what you like.

#3

Thank you, but how to make this formula to appear automatically in every new sheet ?

#4

I think the simplest way it’s when you have a clean sheet with the formula, copy it to a new one before put date in ti.

#5

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.