Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my solution
Just to make sure I was bringing everything dynamically, I first captured the sheet names in the 1st batch macro, then I read the data all through in the 2nd batch macro using the Full Paths built in the 1st macro. Have no idea if this is the most optimal solution but probably very dynamic I'd say.
Cheers,
Used batch macros for the solution. To get sheet names and then to open all the sheets in all files in folder.
Solution.
Here is my submission, perfect use of wildcard macro from crew macros.
Love a good batch macro 🙂