VBA code to create new year and copy down formulas

Hello

I am hoping that can someone can point me n the right direction. I am working on a forecasting sheet where I have the data up to 2012 (in quarters i.e. periods 1, 2, 3 and 4) and have created subsequent columns with formulas which flow down. Can anyone advise a VBA code which I could use to add another set of rows (another year (with quarters)), which would pull down the formulas from the last row above set in each of the columns along the spreadsheet? Ideally I would like to set up a button which I would click and this would another another year as and when required and the formulas would flow down (from the previous year / last quarter). I have tried to record a macro but it doesn't seem to work correctly. I have attached the spreadsheet for example.

Thanks

KTW

Hi Richard

Thanks for your help - it worked!

KTW