When you first start to use Excel, you probably work with files that somebody else set up. Eventually, you’re ready to build a workbook of your own, and this video shows how to make an order form in Excel, starting from a blank workbook.
These instructions will help you make an order form in Excel, with drop down lists to choose products, and another drop down list to select a customer.
The video also shows you to to set up the formulas that return the customer address, and other formulas to get the product price and calculate totals.
This video shows shows how to make an order form in Excel, step by step, starting from a blank workbook. The timeline below the video shows when each step begins.
To follow along, you can get the sample file from my Contextures site. It has the product list and customer list, so you don’t have to spend time typing those.
If you prefer to read the instructions, instead of watching a video, you’ll find those on the How to Create an Excel Order Form page, on my website.
That page has detailed instructions, and all the formulas, and screen shots for each step.
To see how the order form works, you can get the completed file from my Contextures site. The zipped file is in xlsx format, and does not contain any macros.
Hi there, great tutorials!
I am wondering what you do with your order after you take an order. How do you keep the data? Do you have a video for thatV
Thanks
This site uses Akismet to reduce spam. Learn how your comment data is processed.
