title: Copy range sheet1 paste in selected cell sheet 2
body: <p>Trying to simply copy ranges of text from sheet 1 to sheet 2.  I don't want specific data ranges for the paste as I simply want to reuse the data to rotate assigned tasks (sheet 1) to apply to days/workers (sheet 2).</p>
  
  <p>I started with a "record macro" that did not work then using this forum and several other sources ended up with this:</p>
  
  <pre><code>Sub rotationA()
      Sheets("Sheet1").Range("B2:B5").Copy
      Sheets("Sheet2").Select
      Selection.Insert Shift:=xlDown
  End Sub
  </code></pre>
  
  <p>the line --- Sheets("sheet1").Range("B2:B5").copy  indicates error.  I am very new to vb and have rewritten the line a number of ways with no success.  The answers to other's question don't show the code being used in a manner that looks the same to me and I need help understanding this.</p>
  
  <p>Any help is appreciated!</p>