Buzz
Today, Mytour will show you how to connect data between multiple sheets in a Microsoft Excel workbook. This linking process automatically pulls data from one sheet to another and updates the target sheet whenever you modify any column in the source sheet.
Steps
Open a Microsoft Excel workbook. Excel features a green and white icon with the letter "X".
Click on the target sheet from the sheet tabs. The list of sheets appears at the bottom of the Excel window. Click on the sheet you want to link to another.
Click on an empty cell in the target sheet. This will be the destination cell. When you link this cell to another sheet, the data in this cell will automatically sync and update whenever the source cell's data changes.
Type = into the cell to start the formula in the target cell.
Click on the source sheet from the sheet tabs. Locate the sheet you want to pull data from and click its tab to open it.
Check the formula bar. The formula bar displays the value of the target cell at the top of the workbook. When you switch to the source sheet, the formula bar will show an equal sign, the name of the current sheet, and an exclamation mark.
- Alternatively, you can manually type into the formula bar. The formula will look something like =<SheetName>!, where "<SheetName>" is the name of your source sheet.
Click on a cell in the source sheet. This will be the source cell. The source cell can be empty or already contain data. When you link the sheets, the target cell will automatically update with the data from the source cell.
- For example, if you pull data from cell D12 in Sheet1, the formula will be =Sheet1!D12.
Press ↵ Enter to complete the formula and return to the target sheet. Now that the target cell is linked to the source cell, data will automatically be pulled and entered. Any edits made to the source cell will update the target cell accordingly.
Click on the target cell to highlight it.
Click and drag the square icon at the bottom-right corner of the target cell. This action will expand the range of linked cells between the source and target sheets. Extending the initial target cell will also link adjacent cells in the source sheet.
- You can drag and expand the linked cell range in any direction, covering part or all of the sheet.
