Cleaning up a spreadsheet

[cschiller1]

Hi all -

I have a spreadsheet that's a membership list for our neighborhood
organization. It has columns listing years in which dues have been paid,
street number, street address, etc.

I now need a clean version of this spreadsheet so I can import a "send
to" list of email addresses into a bulk email program to send out our
newsletters.

So from the spreadsheet I need to extract three columns: First name
(column N), Last Name (M), and email address (T). I also need to
eliminate any rows in which the email column is blank (we don't have the
address) or which say "no email."

I tried autofiltering but of course the bulk email program, when
importing, sees the whole spreadsheet and not just what I filtered.

I'd be very grateful for any suggestions.

TIA,
Craig

 

[Peo Sjoblom]

Why don't you just copy the filtered data to a new worksheet or a new
workbook?


--


Regards,


Peo Sjoblom

 

[cschiller1]

Jeez. That's WAY too simple. Talk about not seeing the forest for the
trees. Thanks.

 

[Ron.Winkley]

Another option is to select all the rows and columns and sort on the
email column.
All the rows where email is blank will then be grouped at the bottom.
Before doing
this you might want to insert a "master" sort key column. Simply a
column containing
1,2,3,4 . . . etc. Later you can sort on this column to rearrange
the worksheet back
to it's original state, in case you need to.

Cheers,
RonW