I have a list of data, let say from A1 to A20.

I want to update them into A1 of 20 files namely file1.xls, file2.xls
..... file20.xls.

The A1 will goto file1.xls A1
A2 will goto file2.xls A1
......
A20 will goto file3.xls A1.


Is there any macro to update closed file's cells?


regards