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,

Gail,

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

(E-Mail Removed)

Regards


Greg

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

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