Dear Nick
the following macro would do the thing you want.
plz check that all the cells in column A & B you want to run macro on
are numbers. Then in macro code replace the "2" with the start row no.
& "8" with end row no.
& run macro.
Note:-Always take back up copy before running macro.Try this macro
first on sample data
following macro was based on your sample data in question.
Sub Temp()
Dim i As Integer
For i = 2 To 8 'you are supposed to replace this "2" & "8" only
If Cells(i, 2).Value = Cells(i, 1).Value * 1.15 Then
Cells(i, 1).Value = Cells(i, 2).Value
End If
Next i
End Sub
Regards
NC
|