Hi all
I'm trying to create a macro to basically record attendances at meetings.
So far, my macro opens the right sheet of a different book, enters the names on the left most column, the date at the top of the next available row, and deletes any duplicated names.
What I want to be able to do, is match the names on in the left row against the list of names where they were copied from, and if they were present at the meeting, enter an "x" in the row, underneath the date the meeting was on.
Any help will be greatly appreciated
Thank you!
I'm trying to create a macro to basically record attendances at meetings.
So far, my macro opens the right sheet of a different book, enters the names on the left most column, the date at the top of the next available row, and deletes any duplicated names.
What I want to be able to do, is match the names on in the left row against the list of names where they were copied from, and if they were present at the meeting, enter an "x" in the row, underneath the date the meeting was on.
Any help will be greatly appreciated
Thank you!
