Formula referencing to a cell with same name as a Tab

[mjfox52610]

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

[ph1rst]

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)

[Andrew-R]

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)

[AlphaFrog]

Use the Indirect function. This will get the Tab name from cell O1

Please Login or Register  to view this content.

[mjfox52610]

This worked Perfect!!
Thank You!

Use the Indirect function. This will get the Tab name from cell O1

Please Login or Register  to view this content.