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

Steve,

One solution is Autofilter.
--
Earl Kiosterud
www.smokeylake.com

"Steve" wrote in message
...
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

won't I only be able to hide the rows based on y or n entries in column g?
Some transactions will have mulitple no entries prior to a yes entry. I want
to be able to hide the previous no entries as well.

"Earl Kiosterud" wrote:

Steve,

One solution is Autofilter.
--
Earl Kiosterud
www.smokeylake.com

"Steve" wrote in message
...
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