Hi, I have the following code which works perfectly to merge all excel files in a specified folder into 1 file with multiple tabs:
The worksheets that were merged above only contained 1 tab but I now have a scenario where I would like to merge files with multiple tabs.HTML Code:
However, I only want to merge worksheet 2 from each workbook into 1 large workbook with lots of worksheet 2's as separate tabs.
Does anybody know if there is a way that I can modify my code so that I can specify which worksheet I would like to extract?
Thanks very much in advance
:-)
:-)
Bookmarks