Hi,

New to this so here goes. An admitted newbie but prepared to 'do the yards'.

Have a workbook with a number of worksheets.

One of the worksheets is titled 'TEMPLATE' - this is a calculation sheet that is used to determine pricing - on a quarterly basis. A number of cells in this worksheet reference cells in another worksheet titled 'CURRENT RATE' in the same workbook.

Every quarter, we are provided a new 'CURRENT RATE' worksheet.

At the moment, we have to manually rename the existing worksheet 'CURRENT RATE' to a title referencing the quarter that it was applied to ie Rates DEC2011-FEB2012. Then insert the new version worksheet , rename it 'CURRENT RATE'.

The problem is that the cells in the 'TEMPLATE' worksheet that reference the original 'CURRENT RATE' worksheet changes to the new name of the original worksheet. This results in me having to track through the 'TEMPLATE' worksheet to re-reference the affected cells back to 'CURRENT RATE' once I have inserted the new quarterly worksheet (and renamed it to 'CURRENT RATE').

I've looked at absolute values but am getting an alert. I have tried a number of methods ie =ABS('CURRENT RATES'!$D$3), =$'CURRENT RATES'!$D$3 & ='CURRENT RATES'!$D$3

Alert states 'a user has restricted values that can be entered in this cell'