Challenge #19: Excel Record Locator

[Ivyin702]

Please find the attached solution file

Spoiler

 

[Winning_Culture]

Spoiler

#19 solution 

[Chantelb]

Spoiler

[djodts]

Here's my solution.

[getintodata]

Here is my solution!

[JonathanW]

All done! I had trouble reading xls file, so I converted to xlsx prior to starting the challenge.

[mdodrajka]

Looks like almost everyone is picking up data from only Sheet1. In the instructions it was mentioned to take data from each sheets within the excel files. Maybe I'm reading too much into it :0

My solution has two inputs for each sheet with wildcard for the file names. Given the file format is legacy excel, sheet names can only be imported using codes (python etc.).

Spoiler

 

[Aswin]

My solution:

[jdbartosh]

uploaded