SOLVED

How to reference tab names in formulas for tables.

Copper Contributor

So we write a lot of excel sheets for pulling together monthly summaries of individual days, and i was wondering if there was someway to just reference the names of the tabs in a table, say if its just simple names like 1-31

DAS85_0-1675968397532.png

Like, instead of using '1'! for that tab name, use B5!, so i don't have to go in and change the tab name for each individual line.

 

Thank You

3 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

You have to use the function INDIRECT(B5 & "!$G:$G") but INDIRECT is a 'volatile' function meaning it will have to get re-calculated all the time and may have performance hits on excel

That did it, you were just missing a Quotation mark after G, but thank you very much. This was absolutely killing me.
you're welcome and good catch and fixed
1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

You have to use the function INDIRECT(B5 & "!$G:$G") but INDIRECT is a 'volatile' function meaning it will have to get re-calculated all the time and may have performance hits on excel

View solution in original post