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

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
If in Sheet2!A2, your want to link to Sheet1!A2, simply enter this: