Excel linked cells
How can I link two cells on from two different work sheets so that updating info in one will do so in the other and vice-versa? No matter which cell I update I need it to be mirrored by the other cell.
Software/Hardware used:
Software/Hardware used:
ASKED:
July 22, 2008 9:55 PM
UPDATED:
July 23, 2008 12:24 PM
Answer Wiki:
Using OLE (Object Linking and Embedding) or DDE (Dynamic Data Exchange), and setting it to ‘update automatically’, you can achieve this. At any time if the data is changed in source file it gets updated automatically in Destination file (when both are open) or is prompted for update if one is open and changed and other is opened later.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
