I am trying to add a empty column to the right, along with calculating the movement for shifting source data.

Dec 08 Mar 09 Average
30 days $300 $350 16.67%
60 days $250 $200 -20.00%
90 days $200 $375 87.50%
90+ days $15 $25 66.67%
Total $765 $950 24.18%

I will like to add a new column for June figures and get the average column to calculate the figures for last two quarters.

I have tried few VBA variations, but I am struggling to get the right offset pointer for the activecell.

Any help will be really appreciated.

Thanks