title: Excel: Copy Dynamic Range from one worksheet to another
body: <p>I am trying to copy a dynamic range (B12:Lxx)from one worksheet to another. I need the range being copied to stop at the first empty row (there is additional data further down the sheet which I don't want copied).</p>
  
  <p>I am a very basic VBA user so if you could explicitly set out your instructions that would be handy.</p>
  
  <ul>
  <li>Source: Worksheet "MyKPIs" with the dynamic range <strong>B12:Lxx</strong> (column L is set, row numbers are variable BUT must end at the first empty row)</li>
  <li>Target: Worksheet "Month Template", cell B5</li>
  <li>Trigger would be a command button</li>
  </ul>
  
  <p>I have trawled through other articles but have failed to find anything that I could use.</p>
  
  <p>Thanks,
  Hayley</p>