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.
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.