Thread: Using Macro to Lookup and Subtract

Hey guys,

I have been trying to finish up a file and i keep on running into a snag with a vlookup and subtract function.

What i am trying to do is that my sheet 1 is the order info, sheet 2 is the current inventory, and sheet 3 is the delivery database.

When my order is ready then i click D in the column H of sheet 1. This transfers the row of the order info to sheet 3(delivery info). While this happens i need the sheet 2 inventory to decrease by the order that i am delivering.

So basically it needs to lookup the the row in which i pressed "D", find the material name, link it with the sheet 2 material name and then decrease the finished good quantity of that material by the order that i am delivering.

I hope there is a macro that is possible to do this.
I already have the macro to transfer the order to the different sheet and i also have a macro that decreases the inventory level but i dont think i have done it right..

Any Help would be very appreciated, Thanks for your time

Thanks....