How do I link information from one Excel Worksheet to another and have it update automatically?



In order to have Excel data update automatically from one Excel worksheet to another follow the steps below. We will call the Excel worksheet that contains the data you wish to copy Sheet A and Sheet B will be the worksheet where you wish your data to appear:

  1. Open the Excel worksheet (Sheet A) that contains the data that you want to copy to the new worksheet.
  2. Open the Excel worksheet (Sheet B) where you want the data to appear.
  3. Click into the cell that you want to copy in Sheet A.
  4. Press CTRL+C.
  5. Click where you want the information to appear in Sheet B.
  6. On the Home tab, in the Clipboard group, click the arrow under Paste, and then click Paste Special.
    Excel - Paste Special 7. Then Click on “Paste Link” as shown  Excel - Paste Link

 

 

 

 

 

 

 

 

 

 

 
8. Click OK. Your data will update automatically on Sheet B every time you update data on Sheet A.

If you need help with any Excel problem just click on the blue button on the sidebar to the right of this page and ask your question. I will respond promptly.

I look forward to hearing from you.

 

Posted in: Excel Formulas, Excel Tutorials, Microsoft Excel