Changing Circular Reference
 

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,

Changing Circular Reference
 

Gail,

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



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

Changing Circular Reference
 

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,