G'day All,
I have a workbook for a sporting competition containing 1 sheet for each
event to calculate player performance and a sheet showing the championship
table.

After each round I add the results for that event. Then I want to apply a
"leveling" formula based on the total score 'to date' in the championship
table. This creates a circular reference and also changes the leveling
adjustment for previous weeks.

Can anyone suggest a method of achieving the desired effect without entering
the levelling scores by hand?

Thanking you in anticipation,
build