Excel 2007 : Sales and Stock Register

[Avtar101]

Hi I am trying to set up a sales and stock register to help my son in school homework. Have made some attempt but stuck with number calculations & formulats Need to create:
1. Sales invoice page (picks up price/product code from stocktable - when entering the product code)
2. Each sale is added to monthly sales tab. Picked up from auto date (month)
3. Stocktable reduce from each sale
4. Re-stock table - to update stocktable when re-stocked

Copy of same spreadsheet attached. Appreciate any advise/formulas offered. Thanks

[royUK]

sales should be recorded into a table that records date, inv number amount etc. This can then be summarised using a PivotTable or if preferred SUMIF.

Stck figures need to be entered from the invoice and formulas update the current stock

[Avtar101]

Thank you for your feedback. I am not brillant at Excel formulas'. would you able to enter details in the worksheet where the formulas would go. Appreciate your support.