There are many ways to tackle this problem. Here are 2 possible solutions.

1. Use Autofilter
Highlight A1:B1 (I assume that since you say there are 2 columns, you mean
A1 is Item Code and B1 is Quantity, not as you have written it.
Choose DateFilterAutofilter
Select the drop down on column B and select non blanks, this will show just
the items which have quatitities against them.

2. Sort the data
Mark the block of data from A1:B300
DataSort using column B
All the rows with a quatity entered will now be at the top of the list.


--
Regards
Roger Govier
"Herr Li" wrote in message
...
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