Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAOne of the best usage of Batch macro
retaking this to prep for expert exam
proposed solution
bonus question
A neat challenge, thank you, @EddieW - true to real-life use case.
My workflow:
My macro: please update macro input with your file path - I entered a placeholder in the attachment - sorry, not able to share mine due to security. Thanks!
My solution attached.
Unfortunately could not get file 3 to load, because it says that the schema changed. Could not figure out why because all of the columns are the same. In order for the solution to work all the file schemas need to be the same.