Reduction of state

[magda01]

How to use a macro code based on column A (A222, A223, A224 ...)-Sheet1 diminish the values in Sheet2 Column B. If as in the example for the A223 value in cell B2 = 3 (Sheet1), for this value would supposed to be running macros reduce the value in Sheet2 cell B2 and would now get the value of B2 = 341 (34 483). Note that in practice there are many more positions and that the schedule is not exactly as in the example.