Linking Two Worksheets together and back again

K

kking494

I need to be able to link data in one workseet to the second one (which i
know how to do already) but i also want to be able to link it back to the
orginal one i started with. So if i change data in book 1 it will change in
book 2 and vice versa.
 
B

Bob I

You would need to use a Macro to do that. If you input some data in a
cell, it can't also link to cell in a different spread sheet for
updates. And if you "linked" the cell in the other sheet to the one in
this sheet, then you may not edit that cell without breaking the link.
 
Top