Spreadsheet macro help!

[shaneo632]

I've got til Thursday to finish this, and I'm tearing my hair out with panic.

So, my complete moron of a teacher has once again messed up our schedule, and refuses to help us on anything. I've actually written a letter of complaint, but the deadline's in 3 days. Here's the spreadsheet:

http://www.koolpages.com/asdasta/testc.zip

Here's what I need help on. Basically, if you could open the sheet and actually apply it, that'd be cool, but if you just wanna tell me or give any advice, that's cool too, and thanks again:

1) INPUT (MEMBER) = At the moment, you can only order one item, and it automatically appears in the OUTPUT sheet as soon as selected on the box. I want it so that they select the item, platform and quantity, and then they have to click the add to cart button, or it doesn't add to the OUTPUT sheet.

Also, I want the clear cart button to actually work, so it clears and items added to the OUTPUT sheet.

I also want a stock management system. When an item and its quantities are selected, I want it to display under "thanks for shopping here!", the stock left once it's been added to the cart - e.g. "MGS3 has 193 stock remaining." Also, it needs an auto-refill level, so that as soon as the stock drops below 50, it re-fills to 1000.

2) OUTPUT (MEMBER) = I want the output sheet to display the price of the game next to the title and quantity - e.g. You have purchased: MGS3 for the PS2 (100), for £399.99.

I want the output sheet to be able to display multiple games ordered, with multiple quantities and prices, so the there can be a total at the bottom of all of the games ordered. This might require the adjustment of the rows or columns or something.

Many thanks again to anyone who can help. I wouldn't usually ask for stuff like this, but my teacher is an incompetent of the highest order.

[shaneo632]

I just can't do it - I need help!