EconSean
Board Regular
- Joined
- Apr 21, 2002
- Messages
- 129
Greetings all.
I have multiple (20) worksheets, each with approximately 50 formulas. The formulas are all the same currently, in that they reference a particular sheet, call it Region 1. Now, I would like to be able to change this to Region 2, Region 3, etc, depending upon the worksheet that the formula is on.
I am unable to get the standard Edit - Replace to work with the formulas, as I get an "Unable to find match" message.
Anyone have any experience with this?
Thanks in advance for any help.
Kind Regards,
Sean
I have multiple (20) worksheets, each with approximately 50 formulas. The formulas are all the same currently, in that they reference a particular sheet, call it Region 1. Now, I would like to be able to change this to Region 2, Region 3, etc, depending upon the worksheet that the formula is on.
I am unable to get the standard Edit - Replace to work with the formulas, as I get an "Unable to find match" message.
Anyone have any experience with this?
Thanks in advance for any help.
Kind Regards,
Sean