Overview: Learn how to link data in one Excel Spreadsheet to data in cells of another worksheet or workbook using linking formulas.
Pulling All of your Information Together
Excel allows one worksheet to get information from cells in another worksheet. The other worksheet can be inside of the same workbook (file) or in an entirely different one. This is a nice way to use certain sheets for information input (think transactions, prices, account balances) and other worksheets to summarize and and report on the detailed data (think dashboards).
The process of linking data between Excel worksheets and/or workbooks actually only involves a few simple steps:
Open all of the Excel files that you want to link
Pick the linked data’s Destination cell
Select the Soure Data to be linked
Press the Enter key
Linking Excel Worksheets within the Same Workbook
Open your Excel spreadsheet and go to the worksheet where you want to display the linked data and click in the desired destination cell.
Press the “equals” key on your keyboard to begin the linking formula. Then, click on the worksheet (tab) where the source data resides.
Click in the cell where the source data resides.
Wanna See More Great Excel Tips?
These articles have even more Excel Tutorials and quick tips: