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

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
>
>

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
>