UserForm to send to table dependent on category selected.

I have a used user forms in the past for data entry, but I can’t get my head around how to code what I would like to do here.

At the moment I am using 4 tables.

As the data that arrives is not in any sort of order, we have to keep going from one table to another to enter data.

What we would like......
Choose Category, enter Net, Vat, Gross and Reference, click on button Add To Sheet.
There is a Table for each Category.
Entry should go to corresponding cells of the Table in the chosen Category, adding table rows as required, on the active sheet, clear user form ready for next entry.

This would be repeated each month.

Hi kjg

See if this Code in the attached does as you require...

Please Login or Register  to view this content.

Hi kjg

You're welcome...glad I could help.
I've commented the Code as requested.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Please Login or Register  to view this content.

You're welcome...glad I could help. Thanks for the Rep.