Reference sequential tabs, same cell

**sakekobaki** · 07-07-2010, 08:30 PM

Hi

Hope you can help me, and that i sent this to the right place.

I have a simple invoicing workbook that has 150 sequentially numbered identically formatted tabs (1001-1150). It also includes a single cover page that references each tab as a line item and then references 15 cells in each tab to populate an assortment of needed information across a row.

I am still working on this cover page and am hoping you can help me with a way to autofill the cell references from tab to tab. I need the cell reference to stay the same, and the tab reference to change. I cannot figure this out and am hoping I don't have to fill in over 2000 individual references manually to get this going!

thanks for any help!
-mike

**shg** · 07-07-2010, 08:52 PM

If there is a tab name in A1 (e.g., Sheet1), then in another cell you can enter, for example

=INDIRECT("'" & A1 & "'!C12")

If B1 contains the name of a single-cell range on that sheet (like Total) or a cell address (like C12) then

=INDIRECT("'" & A1 & "'!" & B1)

**sakekobaki** · 07-08-2010, 08:16 AM

I see what you've tried to do here SHG, but I cannot get it to work. I've included a small sample doc of what I'm working with- just 5 tabs instead of 150. If you could take another look I'd really appreciate it!

-mike

**sakekobaki** · 07-08-2010, 08:27 AM

Scratch that last one, just tried it again and today it seems to be working! Not sure why it didn't last night, but this is great news- thank you so much for the tip!

-mike