I have worksheet setup to track shipments. each shipment has a transaction
number (Column A). Column G is tracks which shipments have been received with
a Y for yes and a N for No. If a packageis not received, it is returned to
the company and redelivered. A new line is created but it keeps the same
transaction number. Some shipments have 1 line some have and so on and so
forth. it is not constant. What I would like to do is find a way to hide all
the transactions that have been received. If the shipment has 3 entries, 2
with no and 1 with yes. I want to hide all 3 rows.

Thanks for any help you are able to offer.
Steve