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

Posted on 2014-08-25
Last Modified: 2014-09-02
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.
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.
Question by:cssc1
    LVL 44

    Expert Comment

    Have you tried using Excel's advanced filter?  You can put the results anywhere you want.

    Author Comment

    I am trying for an automatic real-time solution.
    LVL 44

    Expert Comment

    autofilter can be automated and that can be on an Excel timer
    LVL 44

    Accepted Solution

    Such a routine can also be kicked off as a result of changes to the worksheet.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now