Creating a Dynamic .XLS file from two other .XLS files

[Guest]

I want to have an .XLS file that is dynamically updated. For example:
A.XLS is updated daily.
B.XLS is updated daily
I want to open C.XLS at the end of each week and it would have the same data
that exists from column A from A.XLS in column A in the file C.XLS.
Similarly, C.XLS would contain the information that was entered in column A
of file B.XLS. Can this be done? If yes, can you point me in the right
direction?
Thanks

 

[Guest]

A 'paste link' function may suit your needs. There are two ways to do the
paste link. One is each cell at file a.xls or b.xls and go to file c.xls
select Edit > Paste Special and click button paste link. If you delete the $
sign (press F2 to delete), you could copy the formula down.
The other one is type the formula at a cell of c.xls by yourself. Below is
the example:
='[c.xls]Sheet1'!$B$15

c.xls = file name
sheet1 = sheet name
$b$15 or b15= cell name
$ means absolute value

If you want to save a backup everyweek, that the other issue. You may post
it at the VBA questions.
Anna