title: How to Insert A New Between After a Specific Row
body: <p>Can you please let me know how I can <br />
  1- insert a new row let say 3 exactly after Existing row 2 <br />
  2- Copy Strings from  1 to 2 <br />
  3- and finally delete 1</p>
  
  <p>The reason that i have to do this is I have some Drop-down, look ups(which I do not know what they call in excel) in row 1 and i can not load the file like this into GIS software so I need to get rid of that, however I still need to keep the Title headers for further referencing.</p>
  
  <p>thanks
  <strong>Update</strong></p>
  
  <pre><code>Sub inserter()
  '
  ' inserter Macro
  '
  
  '
      Rows("3:3").Select
      Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
      Rows("2:2").Select
      Selection.Copy
      Rows("3:3").Select
      ActiveSheet.Paste
      Rows("2:2").Select
      Application.CutCopyMode = False
      Selection.Delete Shift:=xlUp
  End Sub
  </code></pre>