Selecting / Copying information from another file.

I have a macro that pulls data from every excel file in a directory. This is in a file called master.xls

Column K in master.xls contains the file path and file name were the documents are located. Eg c:/excelfiles/1.xls, 2.xls etc.

Each file has a page called Detail; I would like to be able to select the files that I want to copy that Detail page from.

That detail page would then be copied and added to the master.xls I will be selecting more than one file at a time, so as the detail pages are copied over they would have to be renamed e.g. detail 1, detail 2.

Any help would be appreciated.

Sure, Macro Pulls some of the master data over. The file location and name in K is generated by using this

=SUBSTITUTE(SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",

in the excel file

Please Login or Register  to view this content.