Automatically decrease cell 'b1' with the same value that I increased with cell 'a1'

Question

I have a Cell 1 and Cell 2. I want to increase Cell 1 by 5 and decrease Cell 2 the same number as what I have increased in Cell 1. Is there a way to automatically do this and not changing the value of Cell 2 manually? I am using Microsoft Office Excel 2007.

Answer 1

Can you not just do the maths and reference a cell?

So, in Cell 3 have the number 5.

In cell 1 do "current value + Cell3" In cell 2 do "current value - Cell3"

Answer 2

Add this VBA code then enter a value in column C to change A and B.

Private Sub Worksheet_Change(ByVal Target As Range)
  If (Target.Cells.Count <> 1) Then Exit Sub  ' one cell only
  If (Target = "") Then Exit Sub  ' if we pressed delete, do nothing more

  If (Target.Column = 3)  Then   ' we entered value in column C
    With Range(Target.Address).Offset(0, -2)  ' add it to A
      .Value = .Value + Target
    End With
    With Range(Target.Address).Offset(0, -1)  ' subtract it from B
      .Value = .Value - Target
    End With
    Target.ClearContents

    Exit Sub
  End If

End Sub