| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Replace worksheet name in formula linked to a different workbook
When I try to use Find/replace to replace the worksheet name to formula's
linked to many different workbooks, but the worksheet name is the same. It gives us an update values box with the file name and wants us to locate the files. Ex: ='R:\BSP Auditing\FF Div Loan Pwd Surr\[FF Div Auditing.xls]SEP'!$E$39 (It is for multiple files and folders all under BSP Auditing.) Want to change to: ='R:\BSP Auditing\FF Div Loan Pwd Surr\[FF Div Auditing.xls]JAN'!$E$39 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update linked cells within a workbook??? | Links and Linking in Excel | |||
| Copying worksheet from workbook to another | Excel Worksheet Functions | |||
| How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
| Indirect references in a linked formula | Excel Worksheet Functions | |||
Threaded Mode
