linking cells for auto inventory depletion

[chief]

I have an invoice program set up whereby in cells D22 to D40 there is
drop down list which comes up where the user chooses a product by it
code. In cells B22 to B40 is where they input the quantity being sold
In a seperate inventory workbook I have the same product codes an
quantities on hand that is looked after everyday. To save on time o
having to go in and take out of inventory everything that gets sold,
was hoping there is a way to set up some type of coding somewhere tha
will in effect match the invoice program product code to the inventor
program product code, then once that is matched the code will take th
quantity sold in the invoice program and take it out of inventory.
don't mind setting up lots of code, if that is the way it must go. I
this possible to do

 

[Guest]

yes, that can be done. but you didn't provide enouth info
to do anything but agree that it can be done. examples of
your 2 files might help

 

[chief]

the file is too big to send this way, is there an email address i coul
send it to