Sequential Ordering on multiple tabs

**scottsoo9** · 06-06-2011, 03:32 PM

I have an Excel spreadsheet with multiple tabs. I want to number a cell in each tab sequentially from 1 to 484. There are 484 total tabs. So the first tab will be numbered 1 in a cell, the second tab will have number 2 in a cell, third tab will have number 3 in a cell, and so on till tab number 484 will have 484 in a tab.

Is there a way to do this so I do not have to enter each one manually? What would the formula be? Any help will be greatly appreciated. Thanks, Scott

**Haseeb Avarakkan** · 06-06-2011, 03:54 PM

Hello, Try.

define this name. Press Control+F3.

Name: TabName

Refers to:

Please Login or Register  to view this content.

Click OK.

Then right click from the tab name click Select All Sheets

Then enter in a cell

=TabName

press Enter.

NOTE: CELL function is volatile, this will make your file calculation slow.

**MarvinP** · 06-06-2011, 03:57 PM

Hi scottsoo9

This short code will put the sheet number in Cell A1 for as many sheets as you have in your workbook.

Please Login or Register  to view this content.

**scottsoo9** · 06-06-2011, 04:33 PM

Thanks for the quick responses. Which one would be best to use? I tried to do what Haseeb said but it was a little hard to follow. I am not a programmer, so really have no clue how to do this kind of stuff. How would I enter the info that MarvinP gave? Sorry for my lack of knowledge.