title: VBA Insert Text below cell1 based on text in cell1 (text/cell variable; in range)
body: <p>I have a worksheet that is basically a calendar in which I add certain tasks.
  Now I would like for excel to add a certain text below a cell if I enter a certain text in this cell.  </p>
  
  <p>E.g. If I wrote "Evaluation" in cell A1, the text "Personnel" would appear in cell A2. However, if I wrote "Evaluation" in cell B1, the text "Personnel" would appear in B2 and so on. Furthermore, I would also probably write "Evaluation" in more than one cell and the insertion of "Personnel" should apply to all these cells. </p>
  
  <p>Since it is completely variable where I enter the text ("Evaluation") and all other cells also need to be free, I cannot do it with basic Excel formulas. Thus, I think, VBA is the only way to go.  </p>
  
  <p>Unfortunately I have not much experience with VBA, so I would be very glad if you could help me out.</p>