View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] teriboyd1@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Update two cells by changing another

In column A, I have salary. Column B has increase %, column C has
increase amount, column D has total new salary. I need a macro that
allows me to update column B, C, or D by entering infomation in either
of those. So, if someone enters an increase of 5% in column B on a
10,000 salary, then column C should change to $500 and column D should
change to 10,500. Or, if they enter 10,500 in column D, the other two
cells should change, etc.

Can anyone help with this?
Thanks.