Userform combobox to decide which worksheet for data entry

[cklee]

Hi,

I am a complete noob in programming. Appreciate some advices to create a simple data entry workbook using userform.

Example, based on the selection made in a combobox on a userform, I would like to input data to a desired worksheet. For example, I have 10 worksheets in a workbook.
Worksheets name is Div1, Div2 .... Div10. The combobox selection relates to Div1 to Div10. If I select Div1 in the combobox I want all the other entries on the userform to go to Div1 worksheet.
Div2 in combobox to Div2 worksheet and so on. How can I achieve this?

Also to prevent saving duplicate data into the worksheets, I would like to check the values from 2 different columns.
For example, I am entering Location and Unit Number. And I want to ensure that if both Location and Unit Number exist in both columns (on the same row), an error message to be prompted. Else, proceed to saving data.

Any help will be very much appreciated.