Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating 1 worksheet with result from another worksheet | Excel Discussion (Misc queries) | |||
Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions | |||
Updating database worksheet problem (Template Wizard) | Excel Discussion (Misc queries) |