I have a series of entries, say column 1-4 have lastname, firstname,
phone number and email. Now, I want to delete every entry without an
email, is there a way I can automate this without manually searching
for the row without the entry and deleting it?

Thanks for your help


--
mikeyVo
------------------------------------------------------------------------
mikeyVo's Profile: http://www.excelforum.com/member.php...o&userid=34277
View this thread: http://www.excelforum.com/showthread...hreadid=568209

Hi Mike,

Use Data-AutoFilter ,Filter for blank email and delete the filtered rows


Thanks
Xcelion


"mikeyVo" wrote:


I have a series of entries, say column 1-4 have lastname, firstname,
phone number and email. Now, I want to delete every entry without an
email, is there a way I can automate this without manually searching
for the row without the entry and deleting it?

Thanks for your help


--
mikeyVo
------------------------------------------------------------------------
mikeyVo's Profile: http://www.excelforum.com/member.php...o&userid=34277
View this thread: http://www.excelforum.com/showthread...hreadid=568209