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

Question

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.

twifoo · Answer

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

Forum Discussion

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

1 Reply

Resources