How can I automatically update "sub" work books from one central .

[Guest]

I currently have an Invoice register on Excel with a number of columns of
data. The last two columns contain a persons initials in each and each
initial set is the title of another workbook. How can I set up commands to
automatically copy data to these other work books depending on the initials
in the last two columns when I enter fresh data to the invoice register.
Many thanks.

 

[Earl Kiosterud]

Fox,

This can't be done with formulas. I think a macro will be required. It
also sounds as if you will have redundant data, since you will now have it
in two
places. If possible, it may be better to set up the project so that all the
data is on
one notebook. Better yet, one sheet, where practical (similar data, even if
for different people). Take a look at
www.smokeylake.com/excel/excel_truths.htm. Read "Data across multiple
tables. It doesn't hit your situation squarely, but I think it will help.