I'm looking to get my Formula to reference a cell that has the same name as a Tab that has the info i need for the week. If there is an easier way please share.
UPLOAD Roster 2013.xlsm
I'm looking to get my Formula to reference a cell that has the same name as a Tab that has the info i need for the week. If there is an easier way please share.
UPLOAD Roster 2013.xlsm
Can use the INDIRECT() Function:
e.g. =SUM(INDIRECT("'"&CellWithTabName&"!Range'")
where
CellWithTabName is the cell that has the same name as your Tab
Range = Range on the sheet you want to sum (i.e. something like A1:A5, or a named range on that sheet)
Using INDIRECT will be easier if you sort your tab names out, as they're currently inconsistent.
By renaming '1-5-13' to '1-5-2013' I used this formula in G2, copied down and across:
=INDIRECT("'" & TEXT(G$1,"d-m-yyyy") &"'!$Z$" & ROW()+16)
Use the Indirect function. This will get the Tab name from cell O1
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks