Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

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

OllieClarke
15 - Aurora
15 - Aurora

Double macros 🙂

Spoiler
WorkflowWorkflowTwo of these, one for sheet names, one for dataTwo of these, one for sheet names, one for data
mbogusz
9 - Comet

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

Spoiler
Thank you CReW!Thank you CReW!
T_Willins
14 - Magnetar
14 - Magnetar

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)Download Macro (Macro #2)

 

Sheet Name Macro (Macro #1)Sheet Name Macro (Macro #1)

 

WorkflowWorkflow

 

KMiller
8 - Asteroid

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

Spoiler
19-11-2019 09-16-52.png
rmassambane
10 - Fireball
 
JamesCameron
8 - Asteroid

Here's My Effort

 

Spoiler
Directory tool and two macros as per this article here 

JamesCameron_1-1579540462913.png

 

JamesCameron_2-1579540489609.png

JamesCameron_3-1579540537055.png

 

danicahui
8 - Asteroid
Spoiler
Challenge 118 2020-01-21.jpg
johnemery
11 - Bolide

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

 

Spoiler
Capture - macro 2.PNGCapture - 3.PNGCapture - macro 1.PNG
hanykowska
11 - Bolide

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

 

Spoiler
image.pngimage.png
dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1583676629748.png