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?
Solved! Go to 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.
Hey @mceleavey
Thank you very much, it seems to work 🙂
I'll accept as solution 🙂