Creating an Auto-Fill Order Form

%3CLINGO-SUB%20id%3D%22lingo-sub-2043700%22%20slang%3D%22en-US%22%3ECreating%20an%20Auto-Fill%20Order%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2043700%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Afternoon%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20create%20an%20Auto-Filling%20Purchase%20Order%20document%20in%20Excel.%3C%2FP%3E%3CP%3EWe%20produce%20machines%20with%20various%20base%20models%2C%20and%20addons%2C%20so%20we%20were%20looking%20to%20create%20a%20form%20where%20you%20can%20enter%20the%20quantity%20of%20machines%20required%2C%20select%20your%20base%20model%2C%20tick%20the%20addons%20you%20want%20and%20that%20will%20automatically%20populate%20the%20order%20form%20with%20the%20prices%2C%20descriptions%20and%20part%20numbers%20taken%20from%20the%20product%20listing%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20a%20example%20I%20have%20butchered%20from%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcelexposure.com%2Fexcel-video-lesson-vba-walkthrough-1-purchase-order-generator%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelexposure.com%2Fexcel-video-lesson-vba-walkthrough-1-purchase-order-generator%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20no%20longer%20works%2C%20due%20to%20the%20changes%20I%20have%20made%20to%20the%20form%2C%20but%20this%20is%20the%20sort%20of%20thing%20we%20are%20looking%20for.%20Any%20help%20or%20advise%20would%20be%20greatly%20welcomed.%3C%2FP%3E%3CP%3ENote%20that%20this%20example%20is%20based%20upon%20our%20smallest%20model%2C%20we%20do%20have%20products%20with%20around%20a%20dozen%20base%20options%20and%20many%2C%20many%20more%20addons%20to%20choose%20from%2C%20so%20this%20will%20need%20to%20be%20expandable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2043700%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2053157%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20an%20Auto-Fill%20Order%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2053157%22%20slang%3D%22en-US%22%3E%3CP%3Eafter%20some%20thought%2C%20I%20have%20come%20up%20with%20this%20alternative.%20It's%20almost%20there%2C%20just%20needs%20refining%20so%20that%20i%20works%20correctly%20(I%20think).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20would%20be%20welcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 https://excelexposure.com/excel-video-lesson-vba-walkthrough-1-purchase-order-generator/ 

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 advise 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.

1 Reply

after some thought, I have come up with this alternative. It's almost there, just needs refining so that i works correctly (I think).

 

Any advice would be welcome.