View Single Post
  #2   Report Post  
NC
 
Posts: n/a
Default

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