title: Need simple generic vba macro script to change value of cell based on value of other cell
body: <p>Need simple generic vba macro script to change value of cell based on value of other cell.</p>
  
  <p>I have values in the range from e1:e1000. In any of these cell in the range if the value is "x" then its adjacent 2 cells in respective rows should change the value to "y"</p>
  
  <p>eg: if e1 = "x" then f1 = "y" and g1 = "y"</p>
  
  <p>Similarly for other cells too...</p>