I created an Excel file with formulas and links. I want to copy it to different workbooks with different names and I want the data to be updated automatically. Example: workbook name: Test.xls Sheet names: Sheet1, Sheet2
Cell A1 in Sheet1 reads: 999 In cell A5 in Sheet2, I have linked it to cell A1 in Sheet1 and it reads: ='Sheet1'!A1
Now I want to copy this link to another workbook, e.g. FINAL.xls
In workbook FINAL.xls, there are 2 sheets, Sheet1 and Sheet2 In cell A1 in Sheet1, value is 777. When I copy the formula in Sheet2 cell A5, it is linked to workbook Test.xls.
I want it to display what's in Workbook FINAL.xls cell A1.
Can this link automatically be linked to the new workbook?
What I want to achieve is that in whatever Workbook I paste the formula/link, it should give result of that Workbook. There should be no link with the initial workbook.