An Excel macro to identify payment evasion
$10-30 USD
Paid on delivery
BACKGROUND---------------------------------------------------
APMP-NCA is a professional organization in the Greater Washington, DC area that hosts several events per year. We charge members of our organization one price and non-members another price for these events, but our ticketing platform (Eventbrite) cannot connect to our membership database to verify that ticket buyers are representing themselves honestly. The current process requires us to export our event registration list and our membership list from two separate systems and manually cross check the records. As a volunteer organization, none of us have the time to do this. As a result, we lose money on those registrants who have misrepresented themselves as members.
**************************************************
WHAT WE NEED:---------------------------------------------------
We need an Excel template into which we can import two sheets - the membership database export and the exported Eventbrite registration list - and analyze the two to identify non-members who have signed up for our membership price. This analysis should include both the name and the email address. The template should then export the results into a new sheet with names and contact email addresses.
Project ID: #10265806
About the project
Awarded to:
