Forum Discussion

damianknap's avatar
damianknap
Copper Contributor
Jun 08, 2019

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

1 Reply

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    The 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