consecutive numbering on multiple worksheets

  • Thread starter Thread starter s6292
  • Start date Start date
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?
 
In Sheet1 A1 enter:
1
In Sheet2 A1 enter:
=Sheet1!A1+1

and continue with the remaining sheets.
 
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
 
You must log in or register to reply here.

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

Copying multiple cells out of multiple worksheets at same time. 1
Formula from consecutive rows to alternate rows? 2
is it possible to print multiple pages with different numbers 5
Auto Number for Form 4
formula to consecutively number the same cell in different wokshee 2
count worksheets 13
Automatic page numbering with multiple sheets in a workbook 2
Page Numbering in Consecutive Worksheets 2

Back
Top