How can you add two numbers in sheet1, then see your answer in sheet2 in Excel?
How can you add two numbers in sheet1, then see your answer in sheet2 in Excel?
Rajesh Pathak
You can use either of two methods:
Use paste link feature of ‘paste special’. Copy result cell in sheet 1. Go to sheet 2. Click in the target cell. Open paste special using ALT E S V command. Click on paste link button.
Link result cell in sheet1 with target cell in sheet 2 using = sign. Hit control enter.
