deleting blank entries
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 |
deleting blank entries
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 |
All times are GMT +1. The time now is 09:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com