Help with Excel Lists

[Letty]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a huge guest list for a party. Some of the people have given us their emails and some have not. I want to create new sheets - 1 with the email people and 1 with the non email people. I know I can copy and paste, but I want the sheets to automatically update. So, if we get an email for someone, they are automatically moved to the email sheet and removed from the non-email sheet.

I've written and if then statement that transfers the names to the new sheet, but I can't figure out how to transfer only certain names. Do I use a pivot table and if so, how? Any advice would be great, thanks!

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a huge guest list for a party. Some of the people have given us their
emails and some have not. I want to create new sheets - 1 with the email
people and 1 with the non email people. I know I can copy and paste, but I
want the sheets to automatically update. So, if we get an email for someone,
they are automatically moved to the email sheet and removed from the non-email
sheet.

I've written and if then statement that transfers the names to the new sheet,
but I can't figure out how to transfer only certain names. Do I use a pivot
table and if so, how? Any advice would be great, thanks!

I think you are going to a whole lot more trouble that you need to. Why do
you want the names on separate sheets? So you can send email only to those
with email addresses, or print them? You can filter the list and get print
outs of either set. If you are using WORD to send the emails, just set up
the criteria about the existence of the email address.