I would like extract the entire row of information from the received excel
spreadsheet into the non-compliance excel spreadsheet that meets the criteria
of "OLD", "0" "XL", "XC", "XR" or "VAC". There are five columns that could
contain this information. Please note that it is possible for none or many
of these entries to be in each row. I've unsuccessfully tried several things
that did not work (lookup, filter and macro). Any suggestions?