Challenge #466: Organize Oscar Winner Data

[3I_ATLAS]

Nice easy macro challenge and also a good use case for 'New horizontal tab group' (or Vertical if you're @Kenda 😉) if you want to include both macro and workflow in the same screenshot LOL.

Spoiler

[olga_strubbe]

Thank you, Mark @Watermark

This was a great practice for a batch macro and working with file paths.  I admit the macros are still challenging for me,  planning to tackle little by little, this was a good learning experience for me. 

Spoiler

My Batch Macro screenshot: 

[alineruizcampos]

Spoiler

[DaisukeTsuchiya]

Spoiler

[wbasuki]

+My Solution

Spoiler

[JBevan89]

Spoiler

I got there in the end, as it took me quite a while to realise that in the interface designer I need to check autofig by name.  It's good practice for me, as I have not done many macro ones, which i'm planning on doing.

BTW, with the autoconfig in the interface designer with this challenge, if in one of the sheets say there is a space after the heading, like "Year_", will that still capture the data?

I could not help but wonder whether the macro was definitely capturing all the data in this challenge, as the headings were different on each tab.  I do not have the inclination to manually count 2400 to 3000, but my sixth sense does wonder

[ggruccio]

Resubmitting (prior submission did not register as completed).

[Kilbyflow_Designer]

Done!

Spoiler!

[Sebastian_Chaieb2]

I really like this kind of challenges 😁

Spoiler

Macro 

 

[Hub119]

@Watermark removing Warren Miller? Really? Who doesn't like a good ski movie?