Multiple comboboxes populated with same lists; data entered to multiple rows.

Hi there I'm new to comboboxes and was hoping someone could push me in the right direction with a problem I'm having. I'll do my best to be clear as I can with what I'm trying to achieve.

What I want to end up with is a working version of this;
excel image.JPG

I'm trying to record sales of certain sized products, these products can be a specific width, height and length. I want the user to be able to select the sizes from the dropdown boxes and have the data entered on Sheet2 as a sales record.

How would I go about populating all the dropdown comboxes in each column with the same data as shown in the top line. Each selection would also need to be entered on a new line in the record/Sheet2

I've been using the famous contextures PartLocDB to get me started, and if it works fine with just one line of selections. But I was hoping someone could explain to me how to make multiple selections and multiple entries. Thanks

Please Login or Register  to view this content.

Is this solved?

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.