I have a work book which looks after a weekly golf groups scoring. I have designed a userform which I want to use a combobox to choose a player, then another combobox where I chose a date.
Once I have chosen the person and the date I want to input their scores for the 18 holes and once the submit button is pressed those 18 scores are transferred into the corresponding worksheet.
On the work sheet the first persons name is in A1 with hole 1 to hole 18 in the cells below with "total" in cell A20. There are 16 dates in cells b1:s1.
The next persons name is in cell a21 again with hole 1 to hole 18 in the cells below with a "total" in a40.
There are 9 different named players all together.
The code in the userform should first look for the name in combobox1. When it finds the name, it needs to then find the cell which has the date chosen in combobox 2.
When it finds the right spot it then transfers the 18 score into the 18 cells underneath that date.
I would then do the same for each of the players who has turned up that specific week.
The worksheet is sheet4.
Thank you in advance.
Once I have chosen the person and the date I want to input their scores for the 18 holes and once the submit button is pressed those 18 scores are transferred into the corresponding worksheet.
On the work sheet the first persons name is in A1 with hole 1 to hole 18 in the cells below with "total" in cell A20. There are 16 dates in cells b1:s1.
The next persons name is in cell a21 again with hole 1 to hole 18 in the cells below with a "total" in a40.
There are 9 different named players all together.
The code in the userform should first look for the name in combobox1. When it finds the name, it needs to then find the cell which has the date chosen in combobox 2.
When it finds the right spot it then transfers the 18 score into the 18 cells underneath that date.
I would then do the same for each of the players who has turned up that specific week.
The worksheet is sheet4.
Thank you in advance.