title: Vba macro if cell contains value, then input specific text on other cells
body: <p>I have an excel document which has a lot of info and statistics and i am trying to figure out how to solve the following issue:
  If a cell on column E, in the interval E5:E70, contains the "N/A" text (without quotes), i want to automatically input the "N/A" text on several specific cells in the same row </p>
  
  <p>Added an image for reference<a href="https://i.stack.imgur.com/vKNsi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vKNsi.png" alt="image"></a>. 
  Any help would be much appreciated, Thanks !</p>
  
  <p>Latest edit:
  I have attached a copy of the excel, maybe it will be a lot more helpful, for me it just won't work...it's so frustrating...
  <a href="https://drive.google.com/open?id=0B3BWwyZDViCqY1JYajRQZ3plUDA" rel="nofollow noreferrer">excel file</a></p>