MasterOfTheSky
asked on
Excel VBA Question
In the Order Customer file, The A sheet in the file contain prices per unit for all the software packages a mail-order company sells. There is also an B sheet. When the company gets and order from a customer, the person receiving the order gets the quantity of type of product the customer wants to purchase, customer's name and the date. In the A sheet column C, the quantities are written there. Information in the A sheet is used to create invoices for the customer on the B sheet. The Current B sheet is a general invoice "template".
I am trying to write two subs, one that will "ClearData and one that will InvoiceCreation, and attach the buttons at the top of the A sheet. These buttons should do the following.
A. The ClearData sub must be able to clear any quantities from past order from column C of the A sheet. It must be able to delete any old data from the B sheet from row 5 down.
B. The InvoiceCreation sub should begin running immediately after the person taking the order has received the customer information and has entered the quantities in column C of the A sheet. This Sub should utilize input boxes to ask for the customers's name and the data, and it should use these to complete the labels in cells A1 & A2 of the B sheet. Only the relevant data about the products ordered should be transfer to the B sheet, the price for each product ordered (quantity ordered times unit price) should be calculated, it should also calculate the tax for the order (5% sales tax) and the final cost of the order, including tax, in column D. below the prices of individual products, with right labels in column C (such as "5% sales tax" and "Total Cost").
c. To add the finishing touch, add some code to the InvoiceCreation sub to Print the finished invoice.
order-customers.xlsx
I am trying to write two subs, one that will "ClearData and one that will InvoiceCreation, and attach the buttons at the top of the A sheet. These buttons should do the following.
A. The ClearData sub must be able to clear any quantities from past order from column C of the A sheet. It must be able to delete any old data from the B sheet from row 5 down.
B. The InvoiceCreation sub should begin running immediately after the person taking the order has received the customer information and has entered the quantities in column C of the A sheet. This Sub should utilize input boxes to ask for the customers's name and the data, and it should use these to complete the labels in cells A1 & A2 of the B sheet. Only the relevant data about the products ordered should be transfer to the B sheet, the price for each product ordered (quantity ordered times unit price) should be calculated, it should also calculate the tax for the order (5% sales tax) and the final cost of the order, including tax, in column D. below the prices of individual products, with right labels in column C (such as "5% sales tax" and "Total Cost").
c. To add the finishing touch, add some code to the InvoiceCreation sub to Print the finished invoice.
order-customers.xlsx
Would help if I attached it!
Copy-of-order-customers.xls
Copy-of-order-customers.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great Job!! Thank you very much
Open in new window