This interactive demo was created free with Storylane in 8 minutes. Create your own demo
How to Link Cells Between Worksheets in Microsoft Excel
Here's how to do it:
Click the cell where you want the linked data to appear.
Type = in the target cell, then enter the source worksheet name followed by ! and the cell address (e.g., =Sheet2!A1); any changes in the source cell will automatically update the linked cell.
Hit Enter, and the data from the source cell will appear in the target cell.
