Possible shortcut??

[wildcats314]

I have to create several different files that have a formula that references a different worksheet. For instance cell C2=E2+'ABC'!C2, and there are multiple cells with a similar reference. The next file that I will create I will save as, and then I need to update the formula to reference a different worksheet name, say 'ABCD'!. Normally I would just find replace for the worksheet to update all the formulas. However I was wondering if you could have a cell on the worksheet that had ABC, ABCD, etc. in it that could be used in the formula that way I could update the one cell each time I created a new file and everything would automatically change.

[TMS]

Try this, where the sheet name is in cell A1:

=INDIRECT("E2+" & A1 & "!C2")


Regards

[tigeravatar]

wildcats314,

You could use the following formula:

Please Login or Register  to view this content.

Notes:
-This sample formula is meant to be in cell C2 (as per your example)
-This sample formula assumes that the worksheet name is stored in cell B1

Hope this helps,
~tigeravatar