Auto-filling grid challenge

[corey e]

I am sure the answer has already been posted, but I am afraid I do not even know how to search for it - cause i am calling it the wrong thing.
I am an excel novice (I would put me at a 4.5 out of 10)

	A	B	C	D
1				500
2				250
3				350
4	100	1000	200

I want excel to auto fill in the blanks (A-C, 1-3) for me. Column D and Row 4 are totals for each row/column.

Obviously - I know Row 4 needs to equal Column D.

But is there a solver that can find the numbers that satisfy both sums?

can someone suggest a link or tutorial? Or even the right way to identify this "opportunity"?

Thanks
Corey

 

[Bob Phillips]

Row 4 doesn't equal column D!

 

[corey e]

Row 4 doesn't equal column D!

Fair enough.

Now it does.
Is there a way to solve?

	A	B	C	D
1				500
2				250
3				350
4	100	800	200