Quote:
Originally Posted by gcg
I am trying to replace a worksheet name in a formula linked to a different workbook using Excel 2010.
Current: ='M:\ACCOUNTING\Mike\2010 Sales\6 - Period 2010\06152010\[3 - BoulderWE061510.xls]Weekly Sales'!$E$46
Need to Replace with:='M:\ACCOUNTING\Mike\2010 Sales\7 - Period 2010\06222010\[3 - BoulderWE062210.xls]Weekly Sales'!$E$46
ok so here is my issue. Using Excel 2003 and/or 2007 I simply would use Replace 0615 with 0622 I would have to hit esc and it would give me a #REF! error. Then I would replace 6 - Period with 7 - Period and presto it was updated. Now using Excel 2010 when I try to esc it stops.
Anyone?
|
Use FIND and REPLACE this way:
FIND:6 - Period 2010\06152010
REPLACE:7 - Period 2010\06222010
You are now hitting 2 birds with one stone!