Changing Circular Reference

[Guest]

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 where:
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,

 

[Greg Glynn]

Gail,

It's a little confusing. If you send me the .XLS, I can have alook
for you.

(e-mail address removed)

Regards


Greg

 

[Guest]

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