I have 3 files , the third file contains data of the first and second files.

I would like the third file can be updated automatically after changed some
data of the first and second files. How can I do?

in your third file you will have links to the first 2 files

when you open the third file, you just need to go to edit links update
values

you can record a macro (tools macros record new macro) within book 3 that
will do this for you
it gives you code like this:
ActiveWorkbook.UpdateLink Name:="D:\My Documents\Book6.xls", Type:= _
xlExcelLinks

finally, you can rename the macro code that excel has written for you
auto_open() instead of macro1(). do that within VB (press Alt+f11)
when you open the file it will update the links automatically

--
Allllen


"Wu" wrote:

I have 3 files , the third file contains data of the first and second files.

I would like the third file can be updated automatically after changed some
data of the first and second files. How can I do?