Macro to pull multiple files from a directory
Posted on 2011-03-10
Here's the situation.
I have a directory file that has multiple spreadsheets. Each spreadsheet has 3 worksheets within it.
On the second worksheet title "SST" there is data from columns A-I, and a varying amount of rows.
I need a macro that will extract the data from the SST worksheets of all excel files within the directory, and then populate that into a single worksheet.