Forum Discussion
How can I auto-transfer data from one "Sheet" to another "SHeet"in an Excel file?
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:
=Sheet1!A2
