Excel VBA Question

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.

Tester-E-v1.1.xls
EaglemoonAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MSmaxImplementation ConsultantCommented:
Hi, please check attached file for solution.
Just to clarify do you want your calculations to go as follow:
product price (price * qty) *1.05
tax (price * qty) *0.05
Tester-E-v1.2.xls

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
EaglemoonAuthor Commented:
hI msMAX You did and awesome job!! Thank you

Calculations: you have it right!!
EaglemoonAuthor Commented:
Great Job again!! Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.