4-6 hours work - Manually adding data from one column in excel to another sheet in excel based on name.
Goal is to add data to Central Contact Database. This is the only spreadsheet that should be added to.
1. From attendee sheet add to CENTRAL CONTACT DATABASE SHEET the column if they attended, no show etc. On Central CONTACT DATABASE SHEET please input in column Registered 2019 “T”. For additional attendees on day, they will probably need added and make them for column “T” – “showed no registration”. If not on sheet, add contact name, affiliation and email to bottom of sheet.
2. From sheet SPEAKERS 2019 write “Speaker” on CENTRAL CONTACT DATABASE Registered 2019 “T” column. Some will already be on sheet correctly. If not on sheet, add contact name and email to bottom of sheet.