Macro - copy a range and paste it in a new sheet 12 times
 

Hi
How to do a macro that copy a range form sheet1 and paste it into sheet2 12
times changing each time a one factor - in one column is a month, so each
time when macro paste a range, should change a month by 1
Example
sheet1
col col
1 2
month descrip
1 AAA

so macro should copy it all, paste in a new spreadhseet, say Sheet2, copy it
again
nd paste in again in sheet2, below the pasted values and change the month to 2
it should do it 12 times.
Any ideas?
Thanks
Eva