Bring in a Sheet From Multiple Workbooks

Hi All --

Ok, next question. I have 3 Workbooks named:

1) Cash Taxes for Treasury Q4 2014.xlsx

2) Cash Taxes for Treasury Q4 2015.xlsx

3) Cash Taxes for Treasury Q4 2016.xlsx

I need to bring in the same sheet from each 'Cash Taxes - WW$'. Individually, each of these sheets works with my workflow -- but how to I bring in all three at one time to get a single dataset?

Thanks,

Seth

Preparation

Accepted answers

Joe_Mako

Attached is a starting point, this can be turned into a macro with some interface elements to make it reusable. I am happy to work with you or anyone else to adjust this to fit needs.

Load Macro.yxmc

Loading Excel.yxmd

All comments

NickC

Hello Seth,

Try reading in the file with a Wildcard (*).

So in my example I have replaced the Year within your file name to a *. This will automatically open all of the files and stack them on top of each other. This will only work providing the sheet name is the same across those files.

smoskowitz

I tried that and it only brings in one year. I have attached my workflow and 2 years for files. Any help you could provide would be appreciated.

Seth

Cash Taxes for Treasury Q4 2014.xlsx

Cash Taxes for Treasury Q4 2015.xlsx

Cash Taxes.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703