Simple inventory System

Hello all! :-)

I'm trying to make a very simple inventory system so that i can track
stationary as it is delivered, then distributed to the various departments at
my company. Exciting huh?
I can do the simple stuff ok, use vlookup's to get info on stock from
different sheets etc, but here comes the question.

I'm going to use the first sheet as a "form" to enter data in, eg: Item
number 1001, quantity 10. How do i then get the inventory quantity on another
sheet to add these 10 items to a number that is already in that cell.
eg: 25 in stock already, add the 10 new ones, new inventory quantity 35?

Have been trying a few ways but cannot make it work, am pretty good with
things like this normally, but have reached a dead end.

Thanks for any help.

hi,
assuming that the cells that hold the quantity on hand
don't move around and assuming that you have a go button
on the form to trigger your input to be processed...
you can put code behind you button like...
Range(QOH) = Range(QOH)+ txtQTA
where QOH is the cell contain your current quantity on hand
and txtQTA is the quantity to add in your input box on the
form.

-----Original Message-----
Hello all! :-)

I'm trying to make a very simple inventory system so that
i can track
stationary as it is delivered, then distributed to the
various departments at
my company. Exciting huh?
I can do the simple stuff ok, use vlookup's to get info
on stock from
different sheets etc, but here comes the question.

I'm going to use the first sheet as a "form" to enter
data in, eg: Item
number 1001, quantity 10. How do i then get the inventory
quantity on another
sheet to add these 10 items to a number that is already
in that cell.
eg: 25 in stock already, add the 10 new ones, new
inventory quantity 35?

Have been trying a few ways but cannot make it work, am
pretty good with
things like this normally, but have reached a dead end.

Thanks for any help.
.

Thanks a million for the reply.

That seems to make perfect sense, was wondering how to "trigger" the form,
but didn't want to have to get too involved with VB code. Should be able to
do it from the excel interface with a bit of messing round.

Thank you very much for your time.

"Frank stone" wrote:

hi,
assuming that the cells that hold the quantity on hand
don't move around and assuming that you have a go button
on the form to trigger your input to be processed...
you can put code behind you button like...
Range(QOH) = Range(QOH)+ txtQTA
where QOH is the cell contain your current quantity on hand
and txtQTA is the quantity to add in your input box on the
form.

-----Original Message-----
Hello all! :-)

I'm trying to make a very simple inventory system so that
i can track
stationary as it is delivered, then distributed to the
various departments at
my company. Exciting huh?
I can do the simple stuff ok, use vlookup's to get info
on stock from
different sheets etc, but here comes the question.

I'm going to use the first sheet as a "form" to enter
data in, eg: Item
number 1001, quantity 10. How do i then get the inventory
quantity on another
sheet to add these 10 items to a number that is already
in that cell.
eg: 25 in stock already, add the 10 new ones, new
inventory quantity 35?

Have been trying a few ways but cannot make it work, am
pretty good with
things like this normally, but have reached a dead end.

Thanks for any help.
.

Right, i've set up a button, and have named the relevant cells QOH and txtQTA.
What exactly is that line of code you have given me, is that VBA cose, or
can i use it in excel's formual bar?

"Alexthecamel" wrote:

Thanks a million for the reply.

That seems to make perfect sense, was wondering how to "trigger" the form,
but didn't want to have to get too involved with VB code. Should be able to
do it from the excel interface with a bit of messing round.

Thank you very much for your time.

"Frank stone" wrote:

hi,
assuming that the cells that hold the quantity on hand
don't move around and assuming that you have a go button
on the form to trigger your input to be processed...
you can put code behind you button like...
Range(QOH) = Range(QOH)+ txtQTA
where QOH is the cell contain your current quantity on hand
and txtQTA is the quantity to add in your input box on the
form.

-----Original Message-----
Hello all! :-)

I'm trying to make a very simple inventory system so that
i can track
stationary as it is delivered, then distributed to the
various departments at
my company. Exciting huh?
I can do the simple stuff ok, use vlookup's to get info
on stock from
different sheets etc, but here comes the question.

I'm going to use the first sheet as a "form" to enter
data in, eg: Item
number 1001, quantity 10. How do i then get the inventory
quantity on another
sheet to add these 10 items to a number that is already
in that cell.
eg: 25 in stock already, add the 10 new ones, new
inventory quantity 35?

Have been trying a few ways but cannot make it work, am
pretty good with
things like this normally, but have reached a dead end.

Thanks for any help.
.