Dear xl experts how to reference a cell in sheet 1 to another cell in sheet 2 automatically?
For example, sheet 1 cell A1 is 20, A2 is 30, A3 is 40. Sheet 2 cell A1 is 50,
A2 is 60, A3 is 70. How to get the value in sheet 1 & sheet 2 into sheet 3
cell A1, A2,A3,A4, A5 & A6 automatically?
Thank you.
Regards
Sara
