Reference Worksheet Name

L

Leann

I would like to be able to change the name of a worksheet and have it change
in all of the formulas that reference it as well. Is there an easy way to do
this?
 
A

Ardus Petus

Put worksheet name in a definite cell (say A1)

use INDIRECT:
=INDIRECT(A1&"!b10")

HTH
 
A

aidan.heritage

If all the formulas are on the same workbook, then yes - just rename it
and excel will do the rest.
 
L

Larry S

Assuming you have simply hardcoded the name in each formula, then all you
need to do is change the name of the worksheet and EXCEL will change that
reference in all your equations.
 
M

Miguel Zapico

If the worksheet is on an open workbook, all the formulas that refer to that
worksheet should change automatically as you change the name.
Also, you can use Find/Replace from the Edit menu, if you have indirect
formulas. Try first on a backup copy, in any case.

Hope this helps,
Miguel.
 
D

Dave Peterson

Depending on what's in C126, you may need:

=SUM(INDIRECT("'" & C126&"'!e36"):(INDIRECT("'" & C126&"'!e49")))*1000

The additional apostrophes won't hurt if they're not needed.
 
Top