I'd use solver to do it. Let's say A1:I9 is your 9x9 grid, A10:I10 and
J1:J9 is your SUM() of the corresponding row and column, and J10 is the
grand total.
Set up solver:
1. Target cell = J10 - value of 810 (45x18)
2. By changing cells A1:I9
3. Constraint A10:I10 = 45
4. Constraint J1:J9 = 45
5. Constraint A1:I9 = int (if you only want integer)
6. Run solver
Now let's say you want A1 = 6, simply remove A1 from "By changing
cells" and run solver.
Hope it helps.
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=467243