Updating different worksheet with value on current worksheet

[AMarie]

On "worksheet1" I've got several cells with formulas in them. I'd lik
for the values in the cells to automatically update on "worksheet2".
When I change the data on "worksheet1" and the calculations are done
I'd like "worksheet2" to have the updated value without me manuall
changing it.

Please point me in the right direction. I can search the help file t
learn how to do this but the wording I've tried so far hasn't bee
correct. I've tried "link a cell", "update worksheet".

Thanks for reading!
;-

 

[vezerid]

Try, in worksheet2, a formula like:
=worksheet1!A1

This will be a "dynamic copy" of wksht1 data. If they change, wksht2
will also change. The same effect will be created if you use Paste
Special... and click the Paste Link button.

HTH
Kostis Vezerides

 

[AMarie]

Thank you SO much. That's EXACTLY what I needed!!

;-