Trying to create an automated registration system

Hi all

Re-posting this as I've made some headway since my last post.
In a nutshell, I'm trying to make an automated register based on people who attended meetings.

My current process (from start to finish) is as follows:

Enter meeting details inc. expenditures
Enter date
Select attendees from an activeX listbox
(run a macro to copy list of names onto cell adjacent to the form)
Run a macro which copies all information in the form to 2 other workbooks - 1 of which selects the correct sheet, pastes the date in row 1, and the names in column 1.

What I need to do, is with the names that have been copied across, enter an X under the date that was also pasted in this macro.

I've tried formulas in the cells, a variant of the 'Find' function and the H/V Lookup functions but I can't get them to work.

Thanks

EDIT: I have since solved this through mass trial and error. I was on the right lines, but got there in the end.
The final code is here:

Please Login or Register  to view this content.

For the part "(0, TargetCol).Select", I used a code to find the column letter, and dimmed it as TargetCol
Code below:

Please Login or Register  to view this content.

I'm posting this for future reference. In case anyone else would like to automate a registration system from a list of names

For anyone who is/has looked at this
Thank you for anyone who has tried to help.

For anyone who is/has looked at this
Thank you for anyone who has tried to help.