Stock control in Excel

[Jim]

I want to create a simple stock inventory program for our warehouse
using Excel.

I've created a master parts table Database ie Tool number, Customer,
model, and a field for "stock" (qty).

Next I created an entry cell into which I enter a tool number from the
above table. Two cells to the right of the entry cell contain vlookup
functions to pick out automatically the associated customer and model
references. This works fine. Underneath the entry cell I've created a
Received qty cell with a form button next to it. Now I want to assign a
formula/macro to the button which once clicked adds the received qty
into the corresponding tool's "stock" cell within the parts table
database above. I want it to work in such a way that after I've finished
with one tool and then select another then it's associated "stock" qty
would be updated instead. I think the formula would have to recognise
what tool number is currently selected before deciding which "stock"
cell to update.

Anybody's help or suggestions on this would be greatly appreciated.

Many thanks

Jim

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **

 

[Otto Moehrbach]

Jim
A simple macro would do that for you. If you wish, send me, direct via
email, the file that you have. If you feel that your data is proprietary,
just make up some data. It's the ranges that I'm interested in. I'll write
the macro right into your file and send it back to you.
My email address is (e-mail address removed). Remove "Cobia97" from
this address. HTH Otto