Copying from one variable length worksheet to another
<p>Hi newbie (Very New) here,
I have a variable data from 12 sheets (Months). Each sheet shows the spend of a customer for that month, I need to somehow collate each customer onto one sheet.</p>

<p>Normally I would use something simple like a vlookup formula in excel but because new customers may join throughout the year I need a different way of sorting this info. As I would normally use the Account code as my vlookup source.</p>

<p>So I believe I need to use VBA but struggling to find where to even start on something like this.</p>

<p>Any helps would be appreciated. </p>

<p>The first thing I think would be best is to copy each month onto one master sheet then go from there. If so I think I would need to find the amount of rows in the active sheet then copy them to the master sheet but without over writing what I have already copied there.</p>

<p>Could someone point me in the right direction?</p>

<p>Ja</p>