Transfer data from Userform to multiple worksheets

Hi

I have a userform which I would like to transfer the data the several worksheets.

However, I could not get the correct vba code, especially Worksheet Orange - data are transferred to row 17 instead of the next blank.

Kindly assist me with the following:
1) I do not want to transfer the month ie ComboBox1Month. Instead, I hope to have a vba code to search for the month and transfer data to the adjacent columns.
2) Is it possible to auto populate TextBox22AppleTotal with the sum of the other 2 textbox, ie TextBox1AppleS and TextBox2AppleB in the userform? Else, please assist with the vba code to transfer the sum to the "Total Sales" Column.

Attached my worksheet for your assistance.

Thank you.

Regards
Nancy

The reason that data was going to the wrong row in the Orange sheet is that you have some data on rows 147:149.
Try the file I've uploaded, but you'll need to add the code for the Pear & Orange totals in the same manner as I've done for Apples

Hi

Thank you for the solution.

However, it works well if all the fields in the userform are completed. Else, there is an error message runtime 13.

Best regards
nancy

Ok, try this

Please Login or Register  to view this content.

Thank you so much. Works perfectly. Best Regards

Glad to help & thanks for the feedback