Forum Discussion
damianknap
Jun 08, 2019Copper Contributor
Workbook data
Good Morning All,
Is there anyone who can explain how to link data between different excel workbooks, please?
Thank you in advance.
Damian
Is there anyone who can explain how to link data between different excel workbooks, please?
Thank you in advance.
Damian
1 Reply
- TwifooSilver ContributorThe easiest way is to open both workbooks, then type = in the destination workbook and click a cell in the source workbook.
I suggest that you save both workbooks in the same folder. When you reference A1 of Sheet1 in Book1, you may enter this in Book2:
=[Book1.xlsx]Sheet1!A1
If Sheet1!A1 is defined with the name “Basis”, your entry in Book2 becomes shorter, like this:
=[Book1.xlsx]!Basis