How to store a cell value in excel and increment it with adjacent changing value? : <p>Example - I have cell A2 = 10 and B2= 300+A2. The value in B2 will be 310. Now, if I change the value in A2 to 20, I want the value in B2 to automatically change to 330 (and not 300+20). Is there any VBA code or Excel formula which can make this happen?</p>
