Hi guys, I am brainstorming over a logic problem, if anyone could help it would be greatly appreciated.

I have a spreadsheet with 9 columns and 9 rows, I want the sum of every column and every row to be number 45, and if a number in a cell changes then all numbers auto adjust to again produce 45.

Any clues?

Thanks !