So I do event planning for my company. I have a list of people we invite in an excel and then have a seperate sheet for rsvps in that same workbook for those who rsvp. The problem is that a lot of data get lost ( for example I'll add an email address to a person on the rsvp sheet but not the main sheet and it will get lost when we copy the workbook to a new event and delete all the previous rsvps.
Therefore this is what I want done:
I want Column A on my existing sheet to be RSVP. If I type yes in the column I want it to copy the entire row to the rsvp sheet. If I type no it does nothing. I was able to create a macro that did this however, I would like this if possible to update live thus as soon as I type yes it copies and if I delete yes from the column it removes it from the sheet. I also want it to live update, for example if I add an email address to a contact on the main sheet, it automatically updates the email address for the person on the RSVP list.
I have included a list file with a few example names, if you could format this with the macro, and then I'll go back and copy and paste back in my entire list