update data automatically

  • Thread starter Thread starter Wu
  • Start date Start date
W

Wu

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