Hi there,
I've got two shared workbooks A & B working in a network.
How can I link the cells in both workbooks, so the changes in "A" will be reflected in "B" and the changes in "B" will be reflected in "A"?
Regards
Pablo
Hi there,
I've got two shared workbooks A & B working in a network.
How can I link the cells in both workbooks, so the changes in "A" will be reflected in "B" and the changes in "B" will be reflected in "A"?
Regards
Pablo
Pablo
Let's say in Book1 you want Sheet1!A1 to equal the same cell in sheet1 of Book2. In Book1, sheet1, cell A1, use this:How can I link the cells in both workbooks, so the changes in "A" will be reflected in "B" and the changes in "B" will be reflected in "A"?
Book1 will reflect the changes made in Book2 for all linked cells.=[Book2]Sheet1!$A$1
Is this what you are after?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks