software

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 lt;25%

....etc

The %Complete column uses a vailidation list with 0, 50%, lt;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 0.

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

thanks in advance for any advise.

Sincerly,

G

Here is one I did for someone on another group today.

Sub HideRowsPrint()
vlr = Cells(Rows.Count, quot;dquot;).End(xlUp).Row
With Range(Cells(13, quot;Dquot;), Cells(vlr, quot;Dquot;))
.AutoFilter Field:=1, Criteria1:=quot;lt;gt;0quot;
ActiveSheet.PrintPreview
.AutoFilter
End With
End Sub

modified
Sub HideRowsPrint()
vlr = Cells(Rows.Count, quot;equot;).End(xlUp).Row
With Range(Cells(1, quot;equot;), Cells(vlr, quot;equot;))
.AutoFilter Field:=1, Criteria1:=quot;1quot;
End With
End Sub
--
Don Guillett
SalesAid Software

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

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

Or do you want a macro ?
--
Regards Ron de Bruin
www.rondebruin.nlquot;guillaumequot; gt; wrote in message news
gt; Hi,
gt;
gt; I am looking for a scirpt or function that would allow to hide a row based
gt; on a cel value. I looked at some sample macros but not knowledgeable enough
gt; to customize those macros and therefore get an error message. Thanks for any
gt; advise:
gt;
gt; I am creating a small project status report. Each row is an action item. As
gt; follow:
gt;
gt; # Area Task Action Item Owner %Complete
gt; --------------------------------------------------------------------------
gt; 1 Tech Specs Review specs AL 50%
gt; 2 Tech Specs Complete p.4 BH lt;25%
gt;
gt; ...etc
gt;
gt; The %Complete column uses a vailidation list with 0, 50%, lt;25% values.
gt; All I need is an automatic functions that hides for each a row (=an action
gt; item) if the %complete value is equal to 0.
gt;
gt; I am not a macro expert, so I tried some other technics using functions but
gt; unsucessfully.
gt;
gt; thanks in advance for any advise.
gt;
gt; Sincerly,
gt;
gt; G
gt;
gt;
gt;
Let's say that row 1 has quot;# Area Task ....)
That the first record is in row 2 using cells A2:
Use a helper column;
In G1 enter the text Show
In G2 enter =IF(F2=100%,quot;Nquot;, quot;Yquot;) and copy down the column by double
clicking G2's fill handle (little solid square in lower right of active
cell)
Now you have Y's and N's
Select all the data including top row and helper column; Use Data:Filter:
AutoFilter
Now you can have rows with only Y in the SHOW column visible
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;guillaumequot; gt; wrote in message
news
gt; Hi,
gt;
gt; I am looking for a scirpt or function that would allow to hide a row based
gt; on a cel value. I looked at some sample macros but not knowledgeable
gt; enough
gt; to customize those macros and therefore get an error message. Thanks for
gt; any
gt; advise:
gt;
gt; I am creating a small project status report. Each row is an action item.
gt; As
gt; follow:
gt;
gt; # Area Task Action Item Owner %Complete
gt; --------------------------------------------------------------------------
gt; 1 Tech Specs Review specs AL 50%
gt; 2 Tech Specs Complete p.4 BH lt;25%
gt;
gt; ...etc
gt;
gt; The %Complete column uses a vailidation list with 0, 50%, lt;25% values.
gt; All I need is an automatic functions that hides for each a row (=an action
gt; item) if the %complete value is equal to 0.
gt;
gt; I am not a macro expert, so I tried some other technics using functions
gt; but
gt; unsucessfully.
gt;
gt; thanks in advance for any advise.
gt;
gt; Sincerly,
gt;
gt; G
gt;
gt;
gt;
THANK YOU ALL FOR YOUR HELP ! I decided to use the help colum technic....easy
to use.

One recitifcation on the forumla, it should be: =IF(F2=quot;100%quot;,quot;Nquot;, quot;Yquot;) as
I stored percentage in text in order to allow ranges like: lt;50% or 70%-85%.

thanks a lot !

quot;Bernard Liengmequot; wrote:

gt; Let's say that row 1 has quot;# Area Task ....)
gt; That the first record is in row 2 using cells A2:
gt; Use a helper column;
gt; In G1 enter the text Show
gt; In G2 enter =IF(F2=100%,quot;Nquot;, quot;Yquot;) and copy down the column by double
gt; clicking G2's fill handle (little solid square in lower right of active
gt; cell)
gt; Now you have Y's and N's
gt; Select all the data including top row and helper column; Use Data:Filter:
gt; AutoFilter
gt; Now you can have rows with only Y in the SHOW column visible
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;guillaumequot; gt; wrote in message
gt; news
gt; gt; Hi,
gt; gt;
gt; gt; I am looking for a scirpt or function that would allow to hide a row based
gt; gt; on a cel value. I looked at some sample macros but not knowledgeable
gt; gt; enough
gt; gt; to customize those macros and therefore get an error message. Thanks for
gt; gt; any
gt; gt; advise:
gt; gt;
gt; gt; I am creating a small project status report. Each row is an action item.
gt; gt; As
gt; gt; follow:
gt; gt;
gt; gt; # Area Task Action Item Owner %Complete
gt; gt; --------------------------------------------------------------------------
gt; gt; 1 Tech Specs Review specs AL 50%
gt; gt; 2 Tech Specs Complete p.4 BH lt;25%
gt; gt;
gt; gt; ...etc
gt; gt;
gt; gt; The %Complete column uses a vailidation list with 0, 50%, lt;25% values.
gt; gt; All I need is an automatic functions that hides for each a row (=an action
gt; gt; item) if the %complete value is equal to 0.
gt; gt;
gt; gt; I am not a macro expert, so I tried some other technics using functions
gt; gt; but
gt; gt; unsucessfully.
gt; gt;
gt; gt; thanks in advance for any advise.
gt; gt;
gt; gt; Sincerly,
gt; gt;
gt; gt; G
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

The helper column is just not needed. Just use datagt;filtergt;autofiltergt;
lt;gt;100%

or this macro

Sub HideRowsPrint()
vlr = Cells(Rows.Count, quot;equot;).End(xlUp).Row
With Range(Cells(1, quot;equot;), Cells(vlr, quot;equot;))
.AutoFilter Field:=1, Criteria1:=quot;lt;gt;100%quot;
End With
End Sub

--
Don Guillett
SalesAid Software

quot;guillaumequot; gt; wrote in message
...
gt; THANK YOU ALL FOR YOUR HELP ! I decided to use the help colum
gt; technic....easy
gt; to use.
gt;
gt; One recitifcation on the forumla, it should be: =IF(F2=quot;100%quot;,quot;Nquot;, quot;Yquot;)
gt; as
gt; I stored percentage in text in order to allow ranges like: lt;50% or
gt; 70%-85%.
gt;
gt; thanks a lot !
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Let's say that row 1 has quot;# Area Task ....)
gt;gt; That the first record is in row 2 using cells A2:
gt;gt; Use a helper column;
gt;gt; In G1 enter the text Show
gt;gt; In G2 enter =IF(F2=100%,quot;Nquot;, quot;Yquot;) and copy down the column by double
gt;gt; clicking G2's fill handle (little solid square in lower right of active
gt;gt; cell)
gt;gt; Now you have Y's and N's
gt;gt; Select all the data including top row and helper column; Use Data:Filter:
gt;gt; AutoFilter
gt;gt; Now you can have rows with only Y in the SHOW column visible
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;guillaumequot; gt; wrote in message
gt;gt; news
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; I am looking for a scirpt or function that would allow to hide a row
gt;gt; gt; based
gt;gt; gt; on a cel value. I looked at some sample macros but not knowledgeable
gt;gt; gt; enough
gt;gt; gt; to customize those macros and therefore get an error message. Thanks
gt;gt; gt; for
gt;gt; gt; any
gt;gt; gt; advise:
gt;gt; gt;
gt;gt; gt; I am creating a small project status report. Each row is an action
gt;gt; gt; item.
gt;gt; gt; As
gt;gt; gt; follow:
gt;gt; gt;
gt;gt; gt; # Area Task Action Item Owner
gt;gt; gt; %Complete
gt;gt;
gt;gt; gt; --------------------------------------------------------------------------
gt;gt; gt; 1 Tech Specs Review specs AL 50%
gt;gt; gt; 2 Tech Specs Complete p.4 BH lt;25%
gt;gt; gt;
gt;gt; gt; ...etc
gt;gt; gt;
gt;gt; gt; The %Complete column uses a vailidation list with 0, 50%, lt;25%
gt;gt; gt; values.
gt;gt; gt; All I need is an automatic functions that hides for each a row (=an
gt;gt; gt; action
gt;gt; gt; item) if the %complete value is equal to 0.
gt;gt; gt;
gt;gt; gt; I am not a macro expert, so I tried some other technics using functions
gt;gt; gt; but
gt;gt; gt; unsucessfully.
gt;gt; gt;
gt;gt; gt; thanks in advance for any advise.
gt;gt; gt;
gt;gt; gt; Sincerly,
gt;gt; gt;
gt;gt; gt; G
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;