Thank you Greg.. I've sent the file.

"GailK" wrote:

Is there any way of reworking my formula so that a circular reference does
not occur ... how about using a macro?(Excel 2000).

formula in cell F452 where B452 is 2006/09/21 =IF(B452='calc
worksheet'!A5,+'calc worksheet'!H18,IF(B452'calc worksheet'!A5,F452,""))
formula in cell F453 where B453 is 2006/09/22 : =IF(B453='calc
worksheet'!A5,+'calc worksheet'!H18,IF(B453'calc worksheet'!A5,F453,""))
etc .. formula copied to the end of the year...

Calc worksheet whe
column A = date
H18 = volume of calls for that particular date

Purpose: Calc worksheet brings in a daily report via a macro from which
specific cells are copied into a different worksheet. Therefore, as the days
progress I would like to ensure that the data captured on previous days will
remain within the cell relating to that day.

regards,