Using a Userform to transfer data to individual worksheets in specific columns and rows.

Hi Everyone

Hoping someone can help me with some code for a Userform as I have next to no knowledge of VBA.

I have attached a Workbook that I need to start using next week.

It contains 21 worksheets for individual teachers but I have removed several to reduce the size for posting here.

There is a Userform that will have details of monthly statistics for the teachers input. You can select the teacher and month from two combo boxes at the top of the Userform.

The code needs to be able to transfer the data from the Userform to the selected teacher and correct month contained on their respective worksheet. I hope looking at the Userform and worksheet it is self explanatory where the data needs to go.

I hope someone can help as this was very time consuming for me last year inputting the details manually.

Many thanks in advance

Ortz