I am in need of a VB macro that will take data - which is in a rolling 30 work-day table - and copies it to another fixed area/field based on the dates associated in the table. This is because on day 31, the data in Day 1 is lost from the worksheet and requires a lengthy process online to retrieve.

Rephrased, I have a blank calendar that will be my "copy and paste destination." I need a macro to copy the rolling data into this calendar with paste location varying dependent upon the most recent date in the rolling data. Essentially, if A30=2/11/13, copy A1:A30 to B1:B30, if A30=4/2/13, copy A1:A30 to B31:B60, if A30=5/11/13, copy A1:A30 to B61:B90 and so on. These dates I have provided in the example are not accurate, but the general format of the desired macro is there.

I have no experience writing macros in VB and from my talks with a few others I have learned that this is a fairly complex operation for the inexperienced. Please can anyone provide me with the script I need and direct me how to customize it based on actual spreadsheet.