software

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.


Go to MENU BAR - DATA - FILTER - AUTOFILTER and then on Column D -
Filter for quot;BLANKSquot; - Select your rows and quot;DELETE.quot;
Do this with a COPY incase you do not get the results you want.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=516440