Order form with Excel

 Order Form

My order form aims to show;

-Date

-Customer Name/Surname, Address, and Postcode

-Product

-Product price

-Quantity of product

-Subtotal price

-Total price

Starting with the main look of "Order form"

As it can be seen from the attached image above, light blue places are operable parts of the order form. 

Which are "Customer name, adding customer name gives you the result of address and postcode by applying the formula below.

There are two more sheets other than the "Order Form". They are called "Customers" and "Products"

Continuing with Order Form, you can see another example of Order Form from the image below,

Looking into this example, you can spot that the customer and the credentials of the customer have changed.

Moving onto the Product/Price template, this customer buys two of one product that costs £180 which gives a total of £360

Moving forward to the Customer sheet,

There are 10 customers on the database with their address information.

Addresses are grouped under each customer's name with "Data Validation" as "CustomerList" & "CustomerLookup". 

Moving forward to the Product sheet,

There are 10 products on the database with their name and price information. 

Names and Prices are grouped with "Data Validation" as same as done with Customer Sheet, putting product name data under "Product List" and putting price name and price together under "Customer Lookup".