Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Location: Leeds
Posts: 1
Default Circular Reference with Iteration

Hi. New to the board, new to Excel, not new to this Earth.

I have created worksheet to accumulate totals.
Cell A1 - to input latest amount
Cell B1 - to display previous accumulated total prior to latest input at A1
formulae used =+C1
Cell C1 - to display new accumulated total
Formulae used =A1+B1
This creates Circular Reference (B1 and C1 trying to read each other) so I have set Iteration at max1.
This works wonderfully well if A1 is the only cell where I enter data, but, when entering data further into the spreadsheet - cells not linked by any formulae to the 3 mentioned - they repeat their accumulation giving false totals.
So the question is:
Can I preset a disable or isolate on this circular reference whilst entering data
elsewhere? or,
Can I add some form of 'Activate' button which will operate the accumulation and not allow non-activate repeats? or,
Anyone know a better way of achieving target?

Apologies for pre-amble, I come from a pre-techno age.
Thanks in hope
Phil
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
circular reference - iteration rock Excel Worksheet Functions 5 April 22nd 09 04:50 PM
Circular Reference - Why? Alan Smith Excel Discussion (Misc queries) 7 January 3rd 08 04:24 PM
Circular Reference build Excel Worksheet Functions 1 October 19th 07 01:08 PM
circular reference when using a UDF Saira Excel Discussion (Misc queries) 1 September 21st 05 06:39 PM
circular reference when using a UDF Saira Excel Worksheet Functions 1 September 21st 05 06:39 PM


All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"