Challenge #118: Think Like a CSE - A not-so-wild-wildcard input!

[OllieClarke]

Double macros 🙂

Spoiler

WorkflowTwo of these, one for sheet names, one for data

[mbogusz]

Nice solution @dominiklz.  Great idea to use the CReW Macro!

Spoiler

Thank you CReW!

[T_Willins]

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.

Spoiler

Download Macro (Macro #2)Sheet Name Macro (Macro #1)Workflow

[KMiller]

Solution attached. Option 1: manually adjust each spreadsheet to the same schema and sheet names. Option 2: use macros to read everything in.

Spoiler

[JamesCameron]

Here's My Effort

Spoiler

Directory tool and two macros as per this article here 

[danicahui]

Spoiler

[johnemery]

A deceptively tricky challenge, here. That's partially why I do these challenges — to see use cases that I haven't encountered elsewhere.

Spoiler

[hanykowska]

I focused on just bringing in the files, although looking at their structure, they need some further cleaning up...

Spoiler

[dsmdavid]

Spoiler