If you indicate your conversion factors for each row in two different column, say, F and G, you could try something like this:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rAction As Range
Set rAction = Range("B1:D99")
Dim adyC As Long
If Intersect(rAction, Target) Is Nothing Then Exit Sub
If Target.Count > 1 Then Exit Sub
Application.EnableEvents = False
adyC = Target.Column
If adyC = 2 Then
Target.Offset(0, 1).Value = Target.Value / Target.Offset(0, 4).Value
Target.Offset(0, 2).Value = Target.Offset(0, 1).Value / Target.Offset(0, 5).Value
End If
If adyC = 3 Then
Target.Offset(0, -1).Value = Target.Value * Target.Offset(0, 3).Value
Target.Offset(0, 1).Value = Target.Value / Target.Offset(0, 4).Value
End If
If adyC = 4 Then
Target.Offset(0, -1).Value = Target.Value * Target.Offset(0, 3).Value
Target.Offset(0, -2).Value = Target.Offset(0, -1).Value * Target.Offset(0, 2).Value
End If
Application.EnableEvents = True
End Sub
Bookmarks