Updating different worksheet with value on current worksheet
 

On "worksheet1" I've got several cells with formulas in them. I'd like
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 manually
changing it.

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

Thanks for reading!
;-)


--
AMarie
------------------------------------------------------------------------
AMarie's Profile: http://www.excelforum.com/member.php...o&userid=27924
View this thread: http://www.excelforum.com/showthread...hreadid=475835

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

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

;-)


--
AMarie
------------------------------------------------------------------------
AMarie's Profile: http://www.excelforum.com/member.php...o&userid=27924
View this thread: http://www.excelforum.com/showthread...hreadid=475835