Workaround for a circular reference required

[pauldaddyadams]

Hi all

I have a spreadsheet which should balance but doesn’t so therefore I want to lose the balance as the difference is insignificant.

The problem I have is that this creates a circular reference which I need to find a solution to.

What is the best way to achieve this? I am open to any ideas but it needs to be automated as much as possible.

Currently the spreadsheet totals the budget and target rows – if there is a difference between the two I need to lose this in cell G28

I have attached an example

[Alf]

Have you tested using "Goal Seek"?

Goto tab "Data"-> "What if Analysis" and click "Goal Seek"

Based on your uploaded file

Set cell: G49
To value: 0
By changing: G28

Click "ok" twice

Alf