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.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=516440