Add or Less data automatically.

[Tiya]

Hi to All
I am maintaining my stock
Where i want to add and less stock of my items.
Is there any way if i add item it should add in that or if i less it should
less automatically.

E.G.
Item Qty
Pen 6
Tubs 5
etc...
It should ask Option of ADD OR Less
if click on add it add directly in Pen 7
if click on Less it less directly in pen 5
Is any help

Thanks in advance.

Tiya

 

[Simon Lloyd]

You should probably create a userform where you could have a combobox
contain all the items and perhaps a textbox where you could type -1, -2,
-3 etc to remove that quantity or 1, 2, 3 etc to add that quantity!

Regards,
SImon

 

[JLGWhiz]

Check out this site and see if you can use the template for inventory
management.

http://office.microsoft.com/en-us/templates/TC010184581033.aspx?pid=CT101426031033

 

[Tiya]

Thanks Simon for Reply
I don't konw more about Userform and combobox can you give me some help for
crateing this.
Thanks