Custom Data Entry form to post to separate worksheets dependent on a variable

I have a custom data entry form which is working fine. The form completes customer data for reviewing at a later date. I have now been asked to change it so it will seperate the data in to customer's who require some documents sent out and some that dont.

Is it possible to have a combobox on the form and if the options on the combobox are Yes and No (original), when either option is selected the data will complete on to a seperate sheet for cases with documents required or documents not required?

Is this possible or will it have to have two data entry forms?

Many thanks in advance.

I really appreciate all your help

One data entry form will suffice as long as the only requirement is to direct which sheets gets the data. I would use a checkbox control to direct which sheet receives the data.

You will need to upload your workbook with the form if you need help with the code.

Basic code example:

Please Login or Register  to view this content.

Here is a better example, briefly tested, but not fully developed for all of your controls on the form. This should get you going. Note that I am referencing sheet codenames and not worksheet names (matter of preference).

Please Login or Register  to view this content.