Thread: Macro to subtract 2 cells based on the Value

Hey,

I think i am complicating what i am trying to do but as i cant figure anything out what i am looking for is to have a macro that subtracts the value of a cell in Sheet 1 from the value of a cell in sheet 2 if there is "P" on the column J in Sheet 1.

Basically my current program is doing a VLOOKUP and IF in sheet 1 and if the corresponding item no in sheet 2's inventory is greater than/equal to what i need it is prints "P" in column J of Sheet 1.

I have a macro that if there is a "P" then it shifts the row to another worksheet. But what i need is that while it is shifting that row it also subtract the units it is using from sheet 2.

I hope i am been able to explain what i am trying to do. and this possible..
Thanks

They i can upload the file because it is too large....
however i think it is too large because i have copy pasted the formulas till the end like D1009999. so something like that. could that be the reason....

and now i am trying to delete the rows that are there till in the end like all the rows from 4000 but it just hangs whenever i am trying to do that....