i have a large number of excel workbooks, name "file 001", "file 002", ... up to file "384".
in each of these files, a worksheet named "Sheet1" contains data in this range A1:K1.
there is another workbook named "central file", it contains a sheet named "Central sheet".
i need to have a macro in "central file" which can do the following:
copy the contents of A1:K1 from each file ("file 001", "file 002" ... up to "file 384") into a new row (row 1, row 2 ... up to row 384, respectively) in the corresponding columns (A to K) in "central file".
can you help me with a macro code, please?
TIA.
Bookmarks