woodmacnaps
asked on
Changing sheet reference in formulas
Hi Experts,
I have a spreadsheet with formulas referencing a worksheet named "ABCD". I also have a worksheet named "ABCD1". whats the easiest way to change the sheet reference in the formulas from worksheet "ABCD" to "ABCD1".
Thanks
I have a spreadsheet with formulas referencing a worksheet named "ABCD". I also have a worksheet named "ABCD1". whats the easiest way to change the sheet reference in the formulas from worksheet "ABCD" to "ABCD1".
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Match case is a good idea.