How can I auto-transfer data from one "Sheet" to another "SHeet"in an Excel file?

Highlighted
Occasional Visitor

I am trying to find a function that would link data on Sheet 1 of an Excel file to, for instance, Sheet 2 automatically. So when I change the date on Sheet 1 it also changes on Sheet 2.

 

Thanks for your help.

1 Reply
Highlighted
If in Sheet2!A2, your want to link to Sheet1!A2, simply enter this:
=Sheet1!A2