I have folder of Excel workbooks that have names like this:
ArizonaResidential.xlsx
ArizonaNonResendential.xlsx
ArizonaAll.xlsx
MaineResidential.xlsx
MaineNonResidential.xlsx
MaineAll.xlsx
etc.
They each have one worksheet. The worksheets are different formats. I want to end up with one workbook for each state with each of the three types of worksheets in it (residential, nonresidential, and all).
is it possible to use VBA to look for the common string/token in the file name and combine each trio into one workbook? I’ve googled lots but I am just finding examples where the same sheets, same format are either merged into one sheet or other variations with all worksheets of one type. I’m open to utilities or other approaches as well.
ArizonaResidential.xlsx
ArizonaNonResendential.xlsx
ArizonaAll.xlsx
MaineResidential.xlsx
MaineNonResidential.xlsx
MaineAll.xlsx
etc.
They each have one worksheet. The worksheets are different formats. I want to end up with one workbook for each state with each of the three types of worksheets in it (residential, nonresidential, and all).
is it possible to use VBA to look for the common string/token in the file name and combine each trio into one workbook? I’ve googled lots but I am just finding examples where the same sheets, same format are either merged into one sheet or other variations with all worksheets of one type. I’m open to utilities or other approaches as well.