I have a list of names and scores (Col A and B)
The list of names is a subset of the master list of names on another sheet.
Each time I run an event I want to copy the score for each name to the respective name in the master list and the next column. There is a new column for each event.
The subllist of names will vary with each event but will always comprise names that are in the master list.
Top 3 rows of each new column in the master list contain the event date, location and name.
For each name in the sublist, the code needs to copy the score for that event and name, and then paste it into the respective name in the master list, in the next most right column corresponding to the event column.
Can anyone help me in my quest?
The list of names is a subset of the master list of names on another sheet.
Each time I run an event I want to copy the score for each name to the respective name in the master list and the next column. There is a new column for each event.
The subllist of names will vary with each event but will always comprise names that are in the master list.
Top 3 rows of each new column in the master list contain the event date, location and name.
For each name in the sublist, the code needs to copy the score for that event and name, and then paste it into the respective name in the master list, in the next most right column corresponding to the event column.
Can anyone help me in my quest?