View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gall gall is offline
external usenet poster
 
Posts: 10
Default condensing an email list

I have a list of customers. I have three columns: email address, First
name, and last name. I have 2380 rows. In between each customers record in
a blank row.

What I would like to do is create/run a macro that would condense this list
so it gets rid of the empty row between customers and also customers that do
not have an email address.

Thanks in advance!!!!

Tricia Gall