Copy and paste to the last row in a new worksheet
<p>I'm currently trying to copy from one worksheet and paste into a new worksheet using VBA. however i have the following variables </p>

<ul>
<li>The worksheet with data being copied is dynamic. the columns stay the same but the rows change every week.   </li>
<li>The new worksheet which the data will be added to is dynamic. The Columns are the same but the new worksheet rows increase every week( e.g row 700 one week row 800 the next). </li>
<li>The columns (A and BC) that are being copied and pasted are consistent.</li>
<li>The data should be pasted on columns A- BC on the next available row
of the new worksheet</li>
</ul>

<p>I've currently managed to come up with the following code but i keep getting error's and don't know where i am going wrong as i am new to VBA. </p>

<pre><code> Sub CandP()
'
'

Dim Last_Row As Long

Application.ScreenUpdating = False

Last_Row = Range("A2:BC2" &amp; Rows.Count).End(xlUp).Row
Range("A2:BC2").Copy
Windows("Newsheet.xlsm").Activate
Range("$A2:BC$" &amp; last_row).FillDown

End Sub
</code></pre>

<p>All help is appreciated, Thank you </p>