I am new to excel and am working on a project for my ICT A-level.
My workbook is for a hardware ordering company. There are 3 worksheets: Products, Profits and Customer. On the customer page is a userform in which the user enters the customer's details, the hardware they require and the quantitiy of each peice of hardware.
The details are then added to the Customer worksheet.
At the bottom of this page is a button and this is where i need help.

This is what I want the button to do:

1. Increase the numbers in "Amount purchased" column (in the Profits worksheet) by the quantity of each piece of hardware purchased. (eg. When the order contains 4 Intel Pentium Processors, I want to increase the cell in the "amount puchased" column by 4.)

2. Decrese the stock number for the items purchased in the Products worksheet by the quantity chosen.

3. Print an Invoice. (I will create an Invoice worksheet) and carry the information on the Customer worksheet over to that one in a presentable format.

4. If possible, clear all the fields in the customer worksheet and display a message box confirming the actions.

Could someone please help me with this?
I have little knowlege of VB so could you please explain it clearly.

Thankyou in advance.

Henry