Hello,
I am attempting to copy data from various cells( not contigeous) in an xls file with a variable name to another xls file with a static filename. The cells i wish to copy from are all over the place ie. I10,J12,D12,D10 etc, etc. Although these cells remain constant in each xls file with a variable filename.
I wish to paste these cells in the file ( static filename) in A2,B2,C2 etc,etc .

The next time the xls file ( variable filename) is opened I wish to paste the contents of the same cells I10,J12,D12,D10 to the next available line free in the xls file ( static filename).
any and all help appreciated.