consecutive numbering on multiple worksheets

S

s6292

what if I have multiple sheets in a workbook and I want a number in a cell to
increase by 1 consecutively on each worksheet?
 
G

Gary''s Student

In Sheet1 A1 enter:
1
In Sheet2 A1 enter:
=Sheet1!A1+1

and continue with the remaining sheets.
 
B

bj

try a user defined function

Function sht()
sht = ActiveSheet.Index
End Function

you can add a value if you want to start with something other than 1 at
sheet 1
 
Top