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.
Add this VBA code then enter a value in column C to change A and B.



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" 

