title: Excel cell value update macro
body: <p>I have a spread sheet for tracking different savings, so column A has a name, B has a currency value. I want to be able to enter a value in column C and have it update the B cell next to it, then return to 0. For example:</p>
  
  <p>B1 = £50.00</p>
  
  <p>I type -£12.00 in C1</p>
  
  <p>B1 = £38.00</p>
  
  <p>C1 = £0.00</p>
  
  <p>I thought there would be a built in function, but I can't find one. I think I will need to write a macro to do this. Can anyone show me how this would be done? </p>