If you have three excell documents that have common information, and you edit one of the columns information, how do you make the other two excel documents update automatically, so that you do not have to make the change to all three documents?
If you have three excell documents that have common information, and you edit one of the columns information, how do you make the other two excel documents update automatically, so that you do not have to make the change to all three documents?
The Outdoor Accessory People
Hi,Originally Posted by jstnvndn
If you always update one book then the other two could feed off that via VLookup.
If you mean you want to update any one of three, then you will need some VBA code with a Worksheet_Change subroutine.
In either case see David McRitchie's site at http://www.mvps.org/dmcritchie/excel/sheets.htm
hth
---
Si fractum non sit, noli id reficere.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks