Hello,

I am a total n00b in VBA

Conditions:

1. There are multiple workbooks in the folder S:\Schedules
2. A fixed cell (G20) in active Workbook shows the Order Number that is currently running.

Task:

Create a macro that loops through S:\Schedules folder, searching for G20 value in the workbooks (without opening them), and then opens the workbook with matching Order (and if possible, highlights the row with that found Order number)

Thanks for any help.