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.
Is there a way or a macro that would allow me to just combine certain worksheets?
Thanks in advance.