Excel form copy and paste multiple cells

[probio]

Hi everyone,
I have made a user form with a goal to collect some data in excel spreadsheet (columns: Date, Team, Name, and Number of Events). In the column “Name” I need to capture the name of the Associate who is reporting and also names of Associates who are involved in tasks. There are maximum number of 8 Associates involved in tasks but very often, the number of them is less than that. I’d like to make the form work so that every time when the number of associates involved in tasks is less than 8, their names will be recorded and each Date cell next to them needs to get the info about same date, and number of events as well (column 10).
With the code that I made I get date next to the Associate who is reporting and the number of Events in column 10, same row but I don’t get date and number of Events for Associates who are involved.
Any input is appreciated.

Please Login or Register  to view this content.