I am trying to list the employees who have had near misses under their foreman within a date range on I sheet “GC – NM Basic Report” range “B38:T45”.
The data base has both Near Misses and Good Catches in it. The Good Catches are entered by adding “GC – “ at the beginning of the description and the Near Misses are identified by adding “NM – “ at the beginning of their description.
WHAT HAS BEEN DONE
The database has been setup on sheet: “Main Menu”. The Date Range is selectable on sheet “Main” using “Drop Down 1”.
I have filtered out the number of each Near Misses on sheet “Main Menu”. The Near Miss numbers are in range “DF11 : DF1399 also on the Near Miss sheet. The sheet where I plan to put the Near Miss names based on their foreman is “GC – NM Basic Report” range “B38:T45”. The foreman name is also in the database in column “J” under Crew.