PDA

View Full Version : Combine excel workbooks from multiple folder into one workbook



linalin_Sd
03-26-2016, 03:47 AM
I am trying to figure out a method to combine multiple excel workbooks from different folders into one worksheet in one folder.

example:



workbook1
workbook2

work book3
workbook4
workbook5



person1
folder1\p1.xlsx

folder2\p1.xlsx

folder3\p1.xlsx

folder4\p1.xlsx
folder5\p1.xlsx



person2
folder1\p2.xlsx

folder2\p2.xlsx

folder3\p2.xlsx
folder4\p2.xlsx
folder5\p2.xlsx




....for about 100 of these persons.

I want to combine all of the worksheet for person1 into one worksheet. Is there any way to do this?
Alternative is if there is way to print out all the files for person1 first then next person..... it will also work. Thanks for any suggestion.

linalin_Sd
03-26-2016, 03:55 AM
In addition, some of the exist files may not exist.