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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consecutive No'ing WHEN ADDING/DELETING ROWS 2
Automatic page numbering with multiple sheets in a workbook 2
Copying multiple cells out of multiple worksheets at same time. 1
Duplex Printing of Workbook with multiple worksheets 2
Page Numbering in Consecutive Worksheets 2
formula to consecutively number the same cell in different wokshee 2
count worksheets 13
Totaling cells based on input value 1

Top