Quote:
Originally Posted by Tola
How do I change a range of Formula linked to 3 other files ?
Example:
Cell Reference:
A7:='[AAA.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7
A8:='[AAA.xls]Sheet1'!A8+'[BBB.xls]Sheet1'!A8+'[BBB.xls]Sheet1'!A8
Want to change one of the references to '[BBB.xls] to '[CCC.xls] using
wildcard characters but * and ? does not seam to be regognized in find and
repalce ?
|
Hi Tola,
What I understand is that, your are looking to change the existing formulae from BBB to CCC in the third summation part
A7:='[AAA.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7+'[BBB.xls]Sheet1'!A7
1. Place the curosr in A7 Cell
2. Goto Formulae bar
3. Edit the formulae manually in third summation from BBB to CCC
4. Drag the formulae from Cell A7 to till end