• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 134
  • Last Modified:

How to pull names based on date range and a criteria of being a Near Miss?

PROBLEM
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”.
BACKGROUND INFORMATION
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.
DB-1.xlsm
0
cssc1
Asked:
cssc1
  • 3
1 Solution
 
aikimarkCommented:
Have you tried using Excel's advanced filter?  You can put the results anywhere you want.
0
 
cssc1Author Commented:
I am trying for an automatic real-time solution.
Thanks
0
 
aikimarkCommented:
autofilter can be automated and that can be on an Excel timer
0
 
aikimarkCommented:
Such a routine can also be kicked off as a result of changes to the worksheet.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now