Help!!!

[sharcali]

I have a master summary sheet that needs to pull data from the several worksheets from within the same workbook. The only thing I need to change is the reference sheet name. How do I do this without individually changeing each formula.

Thanks

ex.

='I-09-104-NG24 DolEx Sign'!$B$1

The red part is what I need to change.

 

[xenou]

Hi you can use a find and replace - this works in formulas too (in Excel there is options to search "Values" or "Formulas", and "in sheet" or "in entire workbook" - you probably want to search in "Formulas", and "in worksheet" on the summary sheet. Do not check the box for "match entire cell contents".

Find:'I-09-104-NG24 DolEx Sign'!
Replace with:'My New Sheet Name'!

I think this is under the Edit menu, or hit Control + H to bring up the find/replace dialog box.