I'm currently doing a project on Microsoft Excel, the objective is to use it to run a small business. I have a data entry form on one sheet, where if a new item of stock comes in, data about the stock is typed in and a macro copies it across to a stock list on a seperate sheet.

The stock list contains details about all the items in stock, including weight, price, code and quantity (there is around 5 of each item.)

I then have a "make sale" sheet where I have a combo box which looks up the stock list, and the user selects the item they wish to buy and details about the item are displayed in a table on the make sale list, using a lookup formula linked to the stock list. I then have another macro to add these details to a reciept and a sales list.

The problem I am having, is that when a user buys an item, I need to somehow try and automatically reduce the stock level by one! I know this is possible, the examiner issued a report about this, obviously they cannot explain how to do it but they said that it involves programming of some sort.

I have tried to look in some books but I have found nothing specific enough to help me. Does anyone have any idea of what I can do, or give me ideas? I have no knowledge of programming which is the problem...I'd be very grateful if someone could reply!!

Thanks x

Originally Posted by xxxizzyxxx I'm currently doing a project on Microsoft Excel, the objective is to use it to run a small business. I have a data entry form on one sheet, where if a new item of stock comes in, data about the stock is typed in and a macro copies it across to a stock list on a seperate sheet. The stock list contains details about all the items in stock, including weight, price, code and quantity (there is around 5 of each item.) I then have a "make sale" sheet where I have a combo box which looks up the stock list, and the user selects the item they wish to buy and details about the item are displayed in a table on the make sale list, using a lookup formula linked to the stock list. I then have another macro to add these details to a reciept and a sales list. The problem I am having, is that when a user buys an item, I need to somehow try and automatically reduce the stock level by one! I know this is possible, the examiner issued a report about this, obviously they cannot explain how to do it but they said that it involves programming of some sort. I have tried to look in some books but I have found nothing specific enough to help me. Does anyone have any idea of what I can do, or give me ideas? I have no knowledge of programming which is the problem...I'd be very grateful if someone could reply!! Thanks x

Try and use access it is a much better program for this.... what version of Office do you have??? depending on what version will depend on what you are able to do within the suite.