Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home

changing the same formula on multiple sheets

Posted by bob on February 14, 2001 12:37 PM
Hi
I have the same formula embedded in about 30 sheets and I need to modify it. Is there a way to make one universal change or do I have to do it sheet by sheet 30 times? Help.

Thanks.

Bob


Re: changing the same formula on multiple sheets

Posted by Dave Hawley on February 14, 2001 12:49 PM

Hi Bob

You should be able to use the Edit>Replace for this. Select your first sheet then holding down your shift key, select the last sheet. Or right click on a sheet name Tab and select "Select all sheets" then hold down your Ctrl key and select any sheets you don't want.

Go to Edit replace and type your formula in the "Find What" then type the new version in the "Replace with" click Match case and find entire cells only then click OK.

Now right click on the sheet name tab and select "Ungroup sheets"

Dave
OzGrid Business Applications


Re: changing the same formula on multiple sheets

Posted by Bob on February 16, 2001 7:00 AM

Thanks very much Dave.

Bob


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.