Copy value to another worksheet

[rfbolinger]

Say one worksheet lists an updated value for ABC (A1) of $45 (B1) ; I
want to automatically copy that value to another worksheet next to
whereever ABC is located on the second worksheet-- then do the same
with all the other values; ideas?

 

[HKaplan]

Copy the original values in sheet 1 and paste link into sheet 2 where
you want the updated numbers to appear.

Paste link links the data in sheet 1 to sheet 2.

 

[HKaplan]

You need to use paste special to see the paste link button.