How to hide a row based on a cell's value

[wattzz2000]

I have a large sheet that has UPC codes and I want to be able to have the sheet automatically eliminate the cells that have a 0 value.
All the cells contain formulas generating data from numerous tabs.
I am very green as far as VBA is concerned, so step by step directions would be necessary.

The data is contained in cells A33:F2263 and the column that would have a 0 value is D. D has a formula in it causing the several methods I have tried to be ineffective.

I have read Macros would help, but I have no idea how to set one up or add the button to activate it.

 

[Peter_SSs]

Peter:
I changed the original code to this and it seems to work well:

Do you see any flaw in this?

If it is doing what you want then stick with it.

 

[wattzz2000]

Hello Peter:

I have another question for you.

http://www.mrexcel.com/forum/excel-...-bill-materials-several-tabs.html#post4557110

I'm not sure if I am communicating this properly.

 

[wattzz2000]

Here is another post trying to ask for help on the same thing, just stated another way
http://www.mrexcel.com/forum/excel-...idating-data-multiple-sheets.html#post4556571