Need formilas value to dynamicaly update on 2 different worksheets in the same spreadsheet

C

CJCoates

I have a formula in an Excel spreadsheet that gets updated frequently.
When it updates I currently copy and paste the value to another worksheet in
the same spread sheet.
I know that it is possible to have that update automatically, but cannot
figure it out.
I tried Paste Special, but it seems that works between completely separate
documents.

What am I missing?

Thanks

(e-mail address removed)
 
K

Ken Wright

Why would you not just link it with a formula?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
K

Ken Wright

Click into the cell you want the value to go into, then type = and then
using the mouse click into the cell you would have copied the data from and
then hit Enter.

You will now see a formula like =F23 or if it is on another sheet, perhaps
=sheet1!F23

This will now automatically update any time the source data changes.

Regards
Ken...........................
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Paste link only - not value 4
Same number displaying two different dates 3
Differences Between Two Spreadsheets ? 1
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Spreadsheet produces error values 3
Paste Values in linked Cells Only 4
Copy/paste from many worksheets in the same spreadsheet into one r 2

Top