Thread: One to Many VBA code needed

Okay experts, really need some help on this one. I made an example sheet of what I need and attached it. Here is how it needs to work:

(obviously this is just an example)

user selects a letter from A-I in the Letters column.
user selects a number from 1-9 in the numbers column.
user chooses yes/no in yes/no column and enters in comments in comments column.

Easy enough.

Now when they get into the Vegetables column it brings up a small form that I want them to be able to select a vegetable and the quantity and click submit (this will fill in the vegetable column and the qty column). Now, each time they do this it inserts a NEW row below the one they entered and auto fills the above data into the next line for me, only entering a new vegetable and qty.

In other words, for every letter/number combo there may be several vegetables/qty's selected. On the vegetable form, once they are done they will click DONE.

I found bits and pieces of code of what I needed, but not enough to put it all together. I am sure for someone out there, this is a simple exercise

Perhaps there is a better way to do this? Just need ability to have multiple "vegetables" per "letter" and make it so user doesnt have to keep entering same data over and over for every vegetable/qty they enter.



Thanks for your time, I appreciate you all!!!