Re: Hide a series
- From: "Steve" <sgauer@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 8 Aug 2005 20:10:02 -0700
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" <sgauer@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:033368D9-7D3E-47D4-A869-33ACC8139211@xxxxxxxxxxxxxxxx
> >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
>
>
>
.
- References:
- Hide a series
- From: Steve
- Re: Hide a series
- From: Earl Kiosterud
- Hide a series
- Prev by Date: VBE(Visual Basic Editor) Keep focus in VBE
- Next by Date: Re: vlookup question
- Previous by thread: Re: Hide a series
- Next by thread: Lab Management Program
- Index(es):
Relevant Pages
|
