When you say "Roll forward" do you mean add a year to the dates. Eg 20/06/13 to 20/06/14? Yes you are right copy and paste macro is easy, but if you record say G1:G100 and you add some rows say G1:G125 the recorded macro would not pick up any extra rows! if you could post an example of before and after results i'm sure you'r problem will be resolved