Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Circular Reference
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular Reference | Excel Worksheet Functions | |||
Help on Circular Reference, | Excel Discussion (Misc queries) | |||
circular reference when using a UDF | Excel Worksheet Functions | |||
circular reference in VB | Excel Programming | |||
Circular Reference | Excel Programming |