Hi,

I am attempting to update an inventory from an order. I was hoping t
take the item name and compare it to the inventory (the names would b
a combination of letters and number like RF8588). Once the item i
found change the quantity field by the amount in the order field
Essentially, comparing two fields from separate sheets the
adding/subtracting their respective quantities.

The item names will not be sorted in any meaningful order.

I was also hoping to put in an error function in if a) the inventor
gets below a certain quantity and b) if the item number from the orde
cannot be located in the inventory.

I would like to avoid user input as much as possible. Hopefully jus
running the macro in the order spreadsheet and have it update th
inventory only alerting the user when one of the aforementioned error
occurs.

Any pseudo code, specific commands, general advice or redirection to
relevant thread would be greatly appreciated.

Thanks,
Andre

--
merritt
-----------------------------------------------------------------------
merritts's Profile: http://www.excelforum.com/member.php...fo&userid=3580
View this thread: http://www.excelforum.com/showthread.php?threadid=55578