Important notice: All Credly Certification exam badges that have been unclaimed for 30 or more days will expire on August 28, 2024. To keep your badges active, log in to your Credly account and claim your badge before the deadline. (Don’t worry, this does not affect your Community badges!)
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I've used this inception macro (macro within a macro) technique several times for solving this issue. Directory tool grabs all file names; first macro finds all sheets in those filenames; second macro downloads each sheet and combines data.
Révélation
Download Macro (Macro #2)
Sheet Name Macro (Macro #1)
Workflow
Download Macro (Macro #2)
Sheet Name Macro (Macro #1)
Workflow
Solution attached. Option 1: manually adjust each spreadsheet to the same schema and sheet names. Option 2: use macros to read everything in.
A deceptively tricky challenge, here. That's partially why I do these challenges — to see use cases that I haven't encountered elsewhere.
I focused on just bringing in the files, although looking at their structure, they need some further cleaning up...
