That's an incredibly theoretical question.. many more questions come from it
- Do you want the cell that changed to remain the same??
- do you want the other cells in the row that are changing to have a linear
change (ie they ALL change by the same value) or should they changed based on
how big they already are?? (weighted average)
etc, etc

Either way, you have to come up with your method.

To implement it, I believe you will have to trap the 'old' value of the cell
and the new value. That way you can take the difference and spread it out
(as you define it) over the othe cells in the row/column).

Set a module level variable in the selection_change event every time you
change the selection. This will be your old value (** Might store the old
cell address as well)

Then kick off the routine that updates columns and rows in the change event..

If you can't




"kernelwiz" wrote:


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 !


--
kernelwiz