I am a safety manager for a company with around 100 drivers. Some drivers are class "C" and some have commercial licenses (class "A", "B", "D", etc.). Sheet one has ALL the drivers on it regardless of license class. Sheet 2 has my drivers with commercial licenses on it (their paperwork requires has different requirements). When I add a driver to sheet one, column "F" has whatever the class of license is ("A", "B", "C", "D", etc.).
Is there a way to have an entire row in which the value of column F is anything but "C" copied to the next available row on sheet 2?
I'm attaching a sample. Thanks for any help.
Bookmarks