title: Copying different ranges of cell data from one sheet to another
body: <p>I need to be able to copy different ranges of cells from one worksheet to another. For example A1:A4, C3:C7, D3:D6. I need the code to do the following:</p>
  
  <ul>
  <li><p>Copy different data from those cells in the first worksheet (worksheet1) and paste them onto the same line but transposed on the second worksheet (worksheet2). I don't need to keep the original formatting. </p></li>
  <li><p>When pasting the data I need it to find the last row and paste it below that row. </p></li>
  </ul>
  
  <p>I can write a code which will do most of that but I only know how to get the code to do it for one cell range e.g. A1:A4. </p>
  
  <p>Any help would be greatly appreciated. </p>