Locate text then change value in that row

[jjamesw97]

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.

[Leith Ross]

Hello jjamesw97,

This macro will increase the value of cell of the ActiveSheet. If these two cells are on a different sheet then Activesheet will have to be replaced with the Worksheets("Sheet Name") where "Sheet Name" is the name of the worksheet you are using.

Please Login or Register  to view this content.

[jjamesw97]

Thank you Leith, perfect.