deleting any unnessary rows

  • Thread starter Thread starter Herr Li
  • Start date Start date
H

Herr Li

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 Date>Filter>Autofilter
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
Data>Sort using column B
All the rows with a quatity entered will now be at the top of the list.
 
Thanks alot, it really helps£¡
Roger Govier said:
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 Date>Filter>Autofilter
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
Data>Sort using column B
All the rows with a quatity entered will now be at the top of the list.
Click to expand...
 
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 :-)
------------------------------­------------------------------­----------------
 
Yes, Ken, acutally, I am now using the method you mentioned.

Thank you for all you of you again!

Regards

Li Haibo
 
Back
Top