Add or Less data automatically.
 

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

Add or Less data automatically.
 

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


--
Simon Lloyd

Add or Less data automatically.
 

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

http://office.microsoft.com/en-us/te...CT101426031033

"Tiya" wrote:

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

Add or Less data automatically.
 

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

"Simon Lloyd" wrote:


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


--
Simon Lloyd