I am trying to write a sub that would run right after the employee taking the order from the customer has gotten the information from the customer and has entered quantities in column C of the AllProducts sheet. It should use input boxes to ask for the customer name and the date, and it should use these to complete the labels in cell A1 and A2 of the Invoice sheet. It should then transfer the relevant data about products (only those ordered) to the Invoice sheet, it should calculate the prices for each product ordered (unit price times quantity ordered), and it should calculate the tax on the order (5% sales tax) and the total cost of the order, including tax, in column D, right below the prices of individual products, with appropriate labels in column C (such as “5%” sales tax” and Total Cost”).
Then the ClearOld sub should clear any quantities from a previous order from column C of the AllProducts sheet. It should clear any old data from the Invoice sheet from row 5 down.
The AllProducts sheet in the file Tester_E_v1.0.xls has unit prices for all software packages a mail order company sells. It also has an Invoice sheet. Whenever the company takes an order from a customer, the order taker get the customer’s name, the date, and the quantity of each product the customer wants to purchase. These quantities are written in column C of the AllProducts sheet. The information on this sheet is then used to create an invoice for the customer on the Invoice sheet. The current Invoice sheet is a ‘template” for a general invoice.