I have a worksheet that is really two worksheets in one side by side. The
formulas of one of the worksheets refers to cells in the other worksheet. I
would like to move one of these sheets to a different sheet within the
workbook but when I copy it to the other sheet the formulas do not update
correctly. Is there a way to update all of the cell references at the same
time? Here if an example of one of the formulas before it was moved:
=IF(ISERROR(SUM(((B32)/(DAYS360(DATE(2004,12,31),S1,FALSE)))*(360))*(B13) ),"",(SUM(((B32)/(DAYS360(DATE(2004,12,31),S1,FALSE)))*(360))*(B13) )).
Now here is the same formula after the sheet was moved:
=IF(ISERROR(SUM(((#REF!)/(DAYS360(DATE(2004,12,31),H1,FALSE)))*(360))*(#REF !)),"",(SUM(((#REF!)/(DAYS360(DATE(2004,12,31),H1,FALSE)))*(360))*(#REF !))).
Now here is the correction:
=IF(ISERROR(SUM((('YTD
2005'!B32)/(DAYS360(DATE(2004,12,31),H1,FALSE)))*(360))*('YTD
2005'!B13)),"",(SUM((('YTD
2005'!B32)/(DAYS360(DATE(2004,12,31),H1,FALSE)))*(360))*('YTD 2005'!B13)))

How can I avoid this problem or correct every formula on the sheet at the
same time?