Hi,
First post, really hope you can help me.
We are running Orientation sessions for over 2,000 people and we are trying to keep a track of all attendees. Different Departments are filling in their attendance on different dates (individual sheets), but we want to compare their attendance to the master sheet (list of all employees) and return the value of the date they are attending (the name of the worksheet).
I am able to do a vlookup for one sheet, but not multiples, so that regardless of what date they attended, the master sheet will be updated with the date they attended, and if they didn't we will know to re-schedule for a future date.
Hope you can help.
Bookmarks