Need help on deleting rows . Please see inside.

G

Guest

I have a worksheet with 4 columns and about 600 rows. The A,B,C columns have
contents in all their cells. Only a few cells have contents in Column D. What
I need to do is to delete all the rows with it's respect D column cell blank.
In other words, I am going to just keep all the the rows only when their D
column cells have contents. It would be impossible to inspect each row to see
it's column D cell is blank and delete the row. Could anyone provide me with
a solution, maybe it's just a simple macro. But it has mystified me for 2
days now. Thank you in advance.
 
W

wjohnson

Go to MENU BAR - DATA - FILTER - AUTOFILTER and then on Column D -
Filter for "BLANKS" - Select your rows and "DELETE."
Do this with a COPY incase you do not get the results you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
Blank line after control break 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
deleting rows with blank cells after a specified column? 3
Deleting Rows - only deletes content 2
Excel Concatenate with line breaks but ignore blank cells 3
Deleting rows - syntax wrong? 4
Inserting rows using a list of numbers 3

Top