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!