Updating inventory stock using a macro

[ktyoung009]

Hello,

New to the forum, so I apologize for any evidence of being an amateur. To keep it simple I have an inventory containing 5 columns. I am really only concerned with the first and fifth columns. I have a spot where the part number is typed and it automatically fills in the corresponding columns. There is then a quantity withdraw column. I want to create a macro that will search for the part number specified in cell L2 and deduct the quantity specified in cell O2 from the part specified's current stock. I have a basic understanding of VBA but this one has me stumped. The basic idea is to search for the number in L2 and subtract the value of O2 from the cell found offset 4 to the right. Not sure how to attatch files so I hope the explanation makes sense. I want to search column A for the number typed in L2. Then subtract value in O2 from the cell found right 4 cells. Thanks!