Hi,
I am making a PC Games shop management system, its actually very simple. I have a sheet called "stock file" which has all the information about the products. There's a sheet called invoice. When I click a button I want a input box to pop up and ask for the code, when I enter the code I want all relevant product information to be retrieved from the stock file. Then I want to be asked for the quantity. And want that quantity to be entered into a cell so that the price can be calculated.

I also want most of the field from the invoice to be automatically transferred into another sheet called "Sales Record".

I don't know much about VBA Macros so I need help.

You can download the XLS file I'm taking about to understand the thing better. Its around 100KB.

www.avalon.aboho.com/Shop.xls


When you first open the file you can disable macros if you want. I was trying out a lot of stuff, none works.

There are also other sheets and Buttons, whose tasks are self-explanatory. If you could help me out with those I'd be greateful. Thanks.