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:
  1. 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.

  2. Link result cell in sheet1 with target cell in sheet 2 using = sign. Hit control enter.