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