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