Challenge #19: Excel Record Locator

[DavidLane]

Similar solution to the offical one except using the tile tool to create a grouped recordID for filtering out the unwanted values

Spoiler

[balajilolla]

Spoiler

Solution Attached

[ak515155]

Attached is my Solution , Happy learning !!

[Bonero]

my solution

[jarrod]

I don't typically use this method, but this feature has really improved over time

Spoiler

PS, i was just thinking about the comment about not using 2 inputs, but this still scales to 100s of workbooks since the schema doesn't change and the wild card can be used. 

[deviseetharaman]

Spoiler

[Rohit_G13]

Found this very useful to set a workflow for automating a lot of process which include files/reports being dropped into a common folder

Thanks 

Rohit Govind

[Mattyb21]

Solution attached .. 

[Razzle]

My solution using a dynamic input 

[mhou]

🙂