Vba code to populate cells based on textbox value

Hi All

I have the below code which populates a copy of a template sheet called Invoice. It works perfectly. Only problem I have is that the items captured are in random orders. What I want to achieve is to split the way it populates based on a textbox value. Invoice is currrent outcome and New Invoice is the result I want to achieve.

Please Login or Register  to view this content.

Somewhere, i need to add a If statement that checks the following:

Please Login or Register  to view this content.

Hi Dave

Thanks for input. Have attached with a snapshot of UserForm. Will this help?

Hi Dave

I have attached my workbook. Am new to VBA so am struggling slowly but surely to teach myself with the web and this helpful forum.
Instructions as follows:

1. Press 1 & waiter login
2. Press New Table and enter Table no and No guests
3. Press Beer & Choose Amstel
4. Press 1 on Keypad and press capture
5. Press Breakfast & Choose Muesli
6. Press 1 on Keypad and press capture
7. Press Close Table

Then Unhide Table opened and see result. This is current. I want to change my code to allow for the split of Food and beverages as previously explained. Hope this makes sense.

Anyone able to assist

Hi All

I am still trying to find a solution to my problem. Anyone out there care to have a look and see if they can assist