I organise webinars on Zoom every month and have to manage registration and attendance.
After every webinar I have to work with the registration list and two Zoom reports to report on registration and attendance.
Registration wise we collect school email address and personal email address of participants. Participants may use their school email address or personal email address to join the webinar. Sometimes, participants use email addresses not submitted for registration as well.
Looking to have 2 VBA scripts written:
1) Using Zoom report as base, consolidate the 2 zoom reports into 1 -- see attachment 'output1'.
2) Using registration list as base, indicate if email address is found in 'output1' -- see attachment 'output2'.
Looking for freelancers who understand my use case, is a good communicator, skillful and helpful.