Forum Discussion
Changing links to external workbooks
Hi all, I have a workbook set up, let's call it workbook A, and it currently references information in workbook B. Workbook A row 1 has a list of links to set cells in workbook B. I want...
If the links are like
=[B.xlsx]Sheet1!$A$1copy/paste the row with links, select pasted row, Ctrl+H and Replace All from [B.xlsx] on [C.xlsx]