I NEED TO FILTER & LIST THE DATA WHERE THE ITEM DESCRIPTION IS BLANK

I have an Excel Sheet1 where the columns consist of

Item Number      Item Description   Product line       Product Code    Quantity
AAA1                VALVE                ASSEMBLY             05                   2000
BBB2                                             ASSEMBLY             10                       20
CCC3                  BEARING            INDUSTRIAL             12                    200
DDD4                                             INDUSTRIAL              02                  645
EEE5                   WASHER            ASSEMBLY               08                     36

I need to get a list of the Items where the Item Description is blank and copy the Item Number and all the details to Sheet2

Item Number      Item Description   Product line       Product Code    Quantity
BBB2                                             ASSEMBLY             10                       20
DDD4                                             INDUSTRIAL              02                  645

thanks
chaverlyAsked:
Who is Participating?
 
gtglonerConnect With a Mentor Commented:
Try this file:
Book1.xls
0
 
jppintoCommented:
Just use the Data-Filter feature and then select on the Item Description the blanks.

jppinto
0
 
jppintoCommented:
Select the range where you have your data, then go to the Data tab, on the Sort&Filter group click on the Filter button. Then go to your Item Descrpition and click on the down arrow to open the filter menu. Just check the "blanks" and copy and paste your data.

I've attached a simple example.

jppinto
AutoFilter.xlsx
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
chaverlyAuthor Commented:
I have 38, 946 items.  I have to be able to automate this or write a formula.  I am not an Excel expert.  Also, I'm using Office 2007 with ribbons.
0
 
jppintoCommented:
This is the simplest way you can use to do this without formulas or macros!
0
 
chaverlyAuthor Commented:
Worked like a champ.  It takes awhile to run, but is more than worth it.  I can't imagine doing this manually.
0
 
gtglonerCommented:
Thanks for the grade, hope to be helpful to you again in the future.

Glenn
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.