Autohide empty rows

[Noone]

Hi,
I have a rather large calculation sheet which generates order lists.
The order numbers and the calculations for the quantities are all embedded
in the output list

For example
Product Description Price Quantity Extended Price
A $2 3 $6
B $4 0 $0
C $3 1 $3

And the list goes on. I am looking for a way that I can do a check on the
rows which quantity=0 and than hide that row.

Any suggestions?

Michael

 

[Paul B]

Michael, try data, filter, autofilter, filter on the Quantity column then
custum and >0, this will hide all rows with 0

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Noone]

Paul,

Thanks for the tip, I'll try it out.

Michael