Userform with Combo box to paste date to cell range based on each option in drop down

Hi All

Thanks for taking the time to read this.
I have created my first user form, it is pretty basic but I can't work out how to do a combo box change event.
I have a worksheet that when you complete the user form adds the data from column C15 to L15 onwards.
This bit works fine.
I have now added a combo box at the top of the form with each option corresponding to an area on the worksheet. Each area represents a cupboard where our stock is held. What I really want excel to do is paste the data in the next available line of the cupboard based on what the user selects in the combo box, so if cupboard 1 was selected the data goes to cupboard 1 to the next empty row and so on.
Sample sheet and code attached.

A really nice to have but not essential at all is if the first bit is possible, is there code that should the cupboard run out of blank lines when the user form is completed that excel can just insert the data by adding a row in that cupboard location. The only other slight issue with this is that I have conditional formatting in column B & G and a formula in column B that would need to be included in any inserted lines.

Thanks in advance for any assistance, I have been stuck on this for couple days now.
If possible could the code please be posted as I can't always open the updated excel files (apologies for being a pain)

Please Login or Register  to view this content.

With Changes on the Sheet

no more merged cells
1 tabel for the data

Please Login or Register  to view this content.

Kind regards
Leo

Perfect, thank you so much for all your help
It never even occurred to me to use a table