Home

Workbook data

%3CLINGO-SUB%20id%3D%22lingo-sub-678863%22%20slang%3D%22en-US%22%3EWorkbook%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678863%22%20slang%3D%22en-US%22%3EGood%20Morning%20All%2C%3CBR%20%2F%3EIs%20there%20anyone%20who%20can%20explain%20how%20to%20link%20data%20between%20different%20excel%20workbooks%2C%20please%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20in%20advance.%3CBR%20%2F%3E%3CBR%20%2F%3EDamian%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-678863%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678903%22%20slang%3D%22en-US%22%3ERe%3A%20Workbook%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678903%22%20slang%3D%22en-US%22%3EThe%20easiest%20way%20is%20to%20open%20both%20workbooks%2C%20then%20type%20%3D%20in%20the%20destination%20workbook%20and%20click%20a%20cell%20in%20the%20source%20workbook.%3CBR%20%2F%3EI%20suggest%20that%20you%20save%20both%20workbooks%20in%20the%20same%20folder.%20When%20you%20reference%20A1%20of%20Sheet1%20in%20Book1%2C%20you%20may%20enter%20this%20in%20Book2%3A%3CBR%20%2F%3E%3D%5BBook1.xlsx%5DSheet1!A1%3CBR%20%2F%3EIf%20Sheet1!A1%20is%20defined%20with%20the%20name%20%E2%80%9CBasis%E2%80%9D%2C%20your%20entry%20in%20Book2%20becomes%20shorter%2C%20like%20this%3A%3CBR%20%2F%3E%3D%5BBook1.xlsx%5D!Basis%3C%2FLINGO-BODY%3E
damianknap
Visitor
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
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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies