Hi All,

I have a workbook that on a sheet there is a reference to another sheet.

Basically, I will endup with 12 sheets (one for each month) and the formula for the current month data is an amount for the month less last months total. It is in the form of cell AL11 formula is =AM11-Sheet1!AM11

At the start of the month I copy the entire sheet to a new sheet, but the PAGE reference does not stay relative is appears to be always absolute to Sheet1.

I used to do this work on QuttroPro which does allow for the coping and updating of formulas between sheets.

Is this an Excel limitation when coping ?