Help - simple batch macro - multiple sheets

[Hamder83]

Hi 

I need some help getting this to work please.

I'm trying to create a batch macro that can read all .xlsm files from a folder, and pick a specific sheet from each file, and then combine them.

I've attached what I have done. and included two sample files.


Hope this makes sense?

[mceleavey · Accepted solution]

Hi @Hamder83 ,

I've attached a couple of tools and a working example.

The first tool loads in all tab names of all sheets in the folder you've selected, and the second dynamically loads them all in.

You can place a filter tool after the first macro to reduce to the tabs you want if that is applicable.

Hope this helps,

M.

[Hamder83]

Hey @mceleavey 

Thank you very much, it seems to work 🙂 


I'll accept as solution 🙂 

[mceleavey]

[mceleavey]

Hi @Hamder83 ,

Can you please mark it as a solution, it helps the community.

M.