Dear friends,

I have worksheet called products list.
Inside there are 2 columns:
A1: Item Code
A2: Quantity

We have about 300 items. I share this worksheet with my clients. Each time
when my client place order to me, he will fill in the quantity of the
corresponding item.
But of course, my client cannot buy all the items in his order, so for those
item he don't want to buy, he just leave the 'Quantity' cell as blank (he
will not enter the digit zero inside the cell).

After receiving this worsheet, now I have to manually deleted the rows that
contain the item which my client does not want to order.

Can anyone tell me how I can do this job automatically?

Thanks a lot

Li Haibo