How do you automatically update content between excel documents

[jstnvndn]

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?

[Bryan Hessey]

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?

Hi,

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
---