Devam Ediyor

Excel Event Macro Project

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

Beceriler: Veri Girişi, Veri İşleme, Excel

Daha fazlasını görün: event planning macro excel, what does a data entry person do, planning problem, data entry macro, what is macro in excel, when do i get a data entry done, lost excel, event planning, copy paste names in excel, contact excel sheet, excel macro add, update existing macro excel, excel row column, excel macro row, excel delete row, live excel data, excel column update, excel live data, excel column row, project macro, excel 2013 macro, rsvp list, create workbook, excel copy format file, excel file type list

İşveren Hakkında:
( 1 değerlendirme ) Cincinnati, United States

Proje NO: #4456456

Seçilen:

jaylancer43

Please check your PM for details. Thanks

4 gün içinde 35$ USD
(9 Değerlendirme)
3.3

6 freelancer bu iş için ortalamada 190$ teklif veriyor

Teloquence

Consider it done. Check your PM for my bid details.

1 gün içinde 55$ USD
(50 Değerlendirme)
5.2
Solver86

I will provide the Event macro to add and delete. But where is the sample file? I m ready to start. Thanks

1 gün içinde 35$ USD
(5 Değerlendirme)
3.3
evansly

I think I can make this system a lot better then you currently have. I've sent you a PM.

in 15 gün içinde525$ USD
(1 Değerlendirme)
1.8
drevak

I want to do this project.

in 3 gün içinde99$ USD
(1 Değerlendirme)
1.6
ntlabs

I can do this project and I went and carefully read your requirements.

in 3 gün içinde150$ USD
(0 Değerlendirme)
0.0
paris2785

i can do it

in 30 gün içinde275$ USD
(0 Değerlendirme)
0.0