I have an increasing number of files (Project Files) that increase weekly (Approximately 20 a week) they are stored in a Project folder and then in Engineers Name Sub folder and then in Week sub folders
What I want to do is search all sub folders from within a folder for all PJ*.xlxs files and then copy cell values from the individual files and compile them into a master file
I need to copy Individual Cells as shown in Master Document.xlxs this is compiled from files PJ-04-0001.xlxs and PJ-06-0989.xlxs, the Master Document shows the cells to be copied from the Project Files (PJ-04-0001.xlxs and PJ-06-0989.xlxs).
The (Project Files) PJ files are a sample of the format we use.
Master Document.xlsx
PJ-04-0001.xlsx
PJ-06-0989.xlsx
Bookmarks