Hide all rows where one specific cell in that row = 0?

J

jaydevil

Just trying to help my mum complete a stock take for her company. She'
using Excel to calculate the value of the stock with columns for th
code, the name, the quantity, rate and then total (rate * quantity)
Some of the stock isn't always "in stock" but they still stock it o
occasions so it can't be deleted. She wants to be able to hide an
columns that have a total value of 0 quickly. What's the best way to g
about doing something like this? Macro maybe? I don't want to go all th
way through the 2000 somthing items and hide any I see. Any ideas i
that makes sense?

Thanks
Ja
 
J

jaydevil

Does this just get added to the visual basic editor as is or do I have
to edit it in anyway? I've just tried adding it and it seemed to lock
excel, is that because of the amount of rows or is it because it would
be constantly running if I don't set it to a macro? Sorry if I seem to
be asking lots of questions, I haven't used excel for a long time.

Thanks again
 
Top