Code for guest list attendance

Hello all!

EDIT: See attached for a sample workbook with before and after sheets.

I have a list of people (First name, Last name, E-mail address) that have attended my events in the past. Whenever someone I haven't seen before attends one of my events, their information is added to this master list. Then, for each event (one event per column), people would have an integer value in their row where their information resides if they attended the event specified for that column.

I want to make some VBA script that would ask me to enter multiple first and last names, ask for an integer value, and then have it look through this master list and automatically insert this integer in a new column at the end of the spreadsheet for where it matches a first and last name on the master sheet to a first and last name given in the list I gave the script. If a first and last name is not found on the master list but is in the list that the script received, the script would automatically add this new person to the end of the master list and then add the integer value to the new column it has been using since execution.


I'd really appreciate any assistance in getting this written as I'm a newbie when it comes to VBA code.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.