Re: Hide a row based on a cel value

Giganews Newsgroups
Subject: Re: Hide a row based on a cel value
Posted by:  Ron de Bruin (rondebru…@kabelfoon.nl)
Date: Wed, 17 May 2006

> I am not a macro expert, so I tried some other technics using functions but
> unsucessfully.

You can use this Add-in if you want
http://www.rondebruin.nl/easyfilter.htm

Or do you want a macro ?

--
Regards Ron de Bruin
http://www.rondebruin.nl

"guillaume" <guillau…@discussions.microsoft.com> wrote in message news:DCB04F7A-D753-4166-A868-05BD0BF93E…@microsoft.com...
> Hi,
>
> I am looking for a scirpt or function that would allow to hide a row based
> on a cel value. I looked at some sample macros but not knowledgeable enough
> to customize those macros and therefore get an error message. Thanks for any
> advise:
>
> I am creating a small project status report. Each row is an action item. As
> follow:
>
> #  Area          Task            Action Item      Owner        %Complete
>  --------------------------------------------------------------------------
> 1  Tech          Specs        Review specs    AL              50%
> 2  Tech          Specs        Complete p.4    BH              <25%
>
> ...etc
>
> The %Complete column uses a vailidation list with %100, 50%, <25% values.
> All I need is an automatic functions that hides for each a row (=an action
> item) if the %complete value is equal to %100.
>
> I am not a macro expert, so I tried some other technics using functions but
> unsucessfully.
>
> thanks in advance for any advise.
>
> Sincerly,
>
> G

Replies

None

In response to

Hide a row based on a cel value posted by Guillaume on Wed, 17 May 2006