consecutive numbering on multiple worksheets
 

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?

consecutive numbering on multiple worksheets
 

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

and continue with the remaining sheets.
--
Gary''s Student - gsnu200795


"s6292" wrote:

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?

consecutive numbering on multiple worksheets
 

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

"s6292" wrote:

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?