Summarize a List (Non 0's Only) On a Different Sheet

[mgaworecki]

Hi,

I have a sheet with a list of many (about 200) available item and quanities. I would like to, on another sheet, summarize that list by only listing those items with a quantity greater than zero (about 100). Basically, reducing the list to only those items being used, on a different sheet.

I was think that sumproduct could do it but I can not get it to work.

Anyhelp would be appreciated.

Thanks,

Mark

[NBVC]

You can autofilter the list and hide the 0 value items.

Then copy those rows and paste to other sheet.

[mgaworecki]

I ended up doing through VBA since I did not want to use the filter method. Thanks anyway.

Mark