Forum Discussion
How to reference tab names in formulas for tables.
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
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
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
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
