Hi,

I am attempting to update an inventory from an order. I was hoping to take the item name and compare it to the inventory (the names would be a combination of letters and number like RF8588). Once the item is found change the quantity field by the amount in the order field. Essentially, comparing two fields from separate sheets then 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 inventory gets below a certain quantity and b) if the item number from the order cannot be located in the inventory.

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

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

Thanks,
Andrew