I'd apply data|filter|Autofilter to the column B in the original worksheet.

Then filter to show different from 0 (or greater than 0) and then copy those
visible rows/cells to the second worksheet.



albertmb wrote:

Hi everyone, I need some help.

In sheet 1 I have a product list from which I order items every week:
A B
1) ITEM Cases Ordered
2) Banana 3
3) Apples 0
4) Oranges 1

How can I get results in sheet 2 eliminating those items from which I
haven't orderd but in following cells?

A B
1) ITEM Cases Ordered
2) Banana 3
3) Oranges 1

The following is what I managed so far:

A B
1) ITEM Cases Ordered
2) Banana 3
3)
4) Oranges 1

Thank you in anticipation

--

Dave Peterson