Creating an Auto-Fill Order Form

[allongsound]

Good Afternoon,



I am looking to create an Auto-Filling Purchase Order document in Excel.

We produce machines with various base models, and addons, so we were looking to create a form where you can enter the quantity of machines required, select your base model, tick the addons you want and that will automatically populate the order form with the prices, descriptions and part numbers taken from the product listing tab.

I've attached a example I have butchered from Excel Exposure's VBA Walkthrough Tutorial.

It no longer works, due to the changes I have made to the form, but this is the sort of thing we are looking for. Any help or advice would be greatly welcomed.

Note that this example is based upon our smallest model, we do have products with around a dozen base options and many, many more addons to choose from, so this will need to be expandable. (Possibly up to 50 lines...)