VBA Ordering User form for Purchase Ordering.

Hi All,

I've attached a PO request form which has a button listed above to automatically generate a purchase order request ( Well trying to accomplish this )

As you can see, when click on the "Generate Purchase Order Request" button, a user-form pop-up prompting a site,Cost Centre & WBS Code. What i want to achieve is, the site is pulling the sheet tabs listed. Once a tab is selected in the "site drop down" a cost centre name can be then selected (Materials,Rechargeable,Animals . When selecting this it will populate the WBS code information shown below. Then once all the fields are populated, you can click continue. This will then fill out the correct cells on the request like WBS centre, and the vendor name would be updated from the supplier which is being ordered from.

I hope once achieving this and clicking confirm will allow the Tesco's, Asda, Sainsburys information to be listed and quantity's be added to the order request template.

The aim of this project is to minimise human error with product codes/ descriptions/ and which "Farm" the order is based to create a new PO Request.

Once adding the products, i hope to be able to click finish order. It will fully populate the cells required in the PO request form, then to have a button to which i can save as, and it will create the PO request without the module information / button.

I appropriate any help with this, I'm willing to learn as much as possible.

Please find attached the document, and the basic of what I've added. Looking to be pointed in the right direction.

I am looking for additional ideas, like possibly a date drop down calendar to select the date of delivery and another for Date raised

The sample shows static supplies from each vendor. Will that be the case? Or could the supplies all be different?

And is the same true for cost centre?

Hi Bob,

This is an excellent start! I greatly appreciate your help. What I'm requiring now is once selecting the farm, The WBS row will update so all products / WBS selected, product codes and unit prices update on the excel sheet depending on the selection made. Possibly a button to select a date for delivery that populates in the delivery date cell?


Update**
Once again thank you for the progression so far, I'll'll now work through the coding added to understand what input has been made. A button as well on the order form worksheet that saves as a new document but without the macro added. As well when selecting a supplier, It would populate the vendor name field.

The Asda product doesn't list like the other suppliers, how would i fix this?

Product Category can be removed.

For this example I've used 3, potentially there could be 10 suppliers in the near future. Once the fundamental information is done, I'll extend the supplier. It's basically so when I'm away. A user friendly program is in place for whoever is covering my position.

Any ideas you might have please use them. The more use friendly and less manual input. The less errors.

Thanks again for the prompt response.

Update**

Products for suppliers and WBS codes won't be static. I'll increase them with potentially more. I used name manager previously to set the field

Closed at request of OP to post in Commercial Services.

Thread Closed.