I have a folder with 861 Excel files, each one contains anything from 3 to 30 worksheets. As a task for work, I need to open each one, look for sheets called "ABC" and if found, move them to a new workbook. End result should be a workbook with all the ABC sheets.
Any way of doing this automagically? Thanks
I have Excel 2007 and Windows 7 SP1.
Any way of doing this automagically? Thanks
I have Excel 2007 and Windows 7 SP1.