PDA

View Full Version : Combining Sheets into one table from different excel files



mMike01
08-19-2011, 08:05 AM
Hi, I have a bunch of excel files that are all structured the same. I have to compile data in one of the sheets in each file into one table. I tried a macro from called: "Combine all workbooks from one folder" from the KBdbase. I liked it because you just had to put the files in a subdirectory, it also worked but the only problem was that I could not choose which worksheets to combine, it seemed to just combine everything in each file.

Is there a way or a macro that would allow me to just combine certain worksheets?

Thanks in advance.

Kenneth Hobs
08-19-2011, 11:03 PM
Welcome to the forum! Sure, just put the full path and names into an array and iterate through the array. Or put them into a range and iterate the range.