jimmymac91
New Member
- Joined
- Sep 23, 2011
- Messages
- 1
Hi guys.
I have been thinking of a number of ways of doing this but have no idea where to start with the code so would hugely appreciate any help anyone can give. The idea is that I have a spreadsheet with two columns, in column A I have all of my product codes, and in column B their stock level. I want to have a user form with an input box for the Product code and two other input boxes, one to add to the stock level after a delivery and the other to minus from the stock level if a product is sold. So for example I have a product code of ABCDE and stock level of 10,000. An order for 1,000 of product ABCDE come in so I enter the product code ABCDE and 1,000 into the stock sold box, then the stock level drops to 9,000.
Can anyone help?
THANKS!
If I haven't made myself clear please say and ill try to describe it better!
I have been thinking of a number of ways of doing this but have no idea where to start with the code so would hugely appreciate any help anyone can give. The idea is that I have a spreadsheet with two columns, in column A I have all of my product codes, and in column B their stock level. I want to have a user form with an input box for the Product code and two other input boxes, one to add to the stock level after a delivery and the other to minus from the stock level if a product is sold. So for example I have a product code of ABCDE and stock level of 10,000. An order for 1,000 of product ABCDE come in so I enter the product code ABCDE and 1,000 into the stock sold box, then the stock level drops to 9,000.
Can anyone help?
THANKS!
If I haven't made myself clear please say and ill try to describe it better!
