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

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

Thanks alot, it really helps£¡
"Roger Govier" bl...
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

Another option is to select the colomn with the blanks, do edit / go to /
special / blank cells only, then do edit / delete / Entire row.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Herr Li" wrote in message
...
Thanks alot, it really helps£¡
"Roger Govier"
bl...
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

Yes, Ken, acutally, I am now using the method you mentioned.

Thank you for all you of you again!

Regards

Li Haibo


"Ken Wright" ...
Another option is to select the colomn with the blanks, do edit / go to /
special / blank cells only, then do edit / delete / Entire row.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------?-----------------------------?---------------
It's easier to beg forgiveness than ask permission :-)
------------------------------?-----------------------------?---------------


"Herr Li" wrote in message
...
Thanks alot, it really helps£¡
"Roger Govier" bl...
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