View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil Neil is offline
external usenet poster
 
Posts: 173
Default Using Macro to hide rows that have a "0" quantity value

Hi all and thanks for any help at all.

Basically Im creating a full list of all the parts we carry in our company.

Every single part(row) will start off with a quantity of 0 and have the
description next to it etc.

If I put a quantity greater than 0 in the row for that part, I want to be
able to push cntrl+C to hide all the rows(parts) that are 0 quantity and only
show the rows that have quantity greater than 0.

Then if I want to see everything again that has the 0 quantity, to push
cntrl+B.

Thanks for any help!

Sincerely


Neil