I have an inventory list that I want a macro to be able to change values based on the inputs. The inputs are the name of the item and the amount to change the count by. This is operating between 2 sheets.
Currently I have this line to locate the cell that has the item name C5, and return the 6th column of that row which is the value.
=CELL("address",INDEX('Master Tool List'!A2:K1000,MATCH('Tool Change'!$C$5,'Master Tool List'!D2:D1000,0),6))
I now want to increase or decrease the value of that cell by an input number C7, how can I code this in VBA?
Thanks.
Bookmarks