I have a multi-worksheet model, and I'm getting some wierd results which I think may be caused by a circular reference.
In broad terms this is what (the relevant bit of) my model does:-
I import a list values into column a in sheet 1.
I manually enter adjustments into columns b-e. Column f is a subtotal.
Sheet 2 copies the values from column a in sheet 1, and then aportions them according to pre-defined criteria formula in sheet 2. The apportioned values are listed in a later column in sheet 2.
Back in sheet 1, column g pulls in the apportioned values column from sheet 2.
Column h is a futher sub-total, which is then used to populate another sheet elsewhere in my model.
The strange values seem to be related to the rows which include an apportioned figure from sheet 2.
This sounds like a circular reference issue, but I am no expert on such things.
Can anyone tell me if my logic is flawed, or if I have done something which I must avoid? And if so, how I might avoid it.
And can anyone point me at any articles on the web dealing with such scenarios in multi-sheet models, what you mustn't do, and how to avoid it?
Many thanks in anticipation.