Balanced Sum

you'd need vba and mac 2008 doesnt support it,

There has to be some way I can do this. Can anyone help? Is there another version of excel I can use on my mac that can do this?

Hi defeater,

Read about the newer version of Excel for the Mac at http://www.macworld.com/article/1551...el2011faq.html
I believe this has Macros and uses VBA to accomplish what you are trying to do.

OK defeater,
Find the attached that does what you request. You will need to find the VBA code behind the worksheet to see how it works.

Hi defeater,
When Martin said in post #2, you need VBA to do that, he was correct. Just having 2011 Mac version of Excel was a start as it has VBA while 2008 does not. As I wrote the code I knew you would have problems understanding what was happening. You need to learn some VBA. Look behind the worksheet (not in a module) to see the code that does your problem. Here is the topic list for understanding how the problem was done.

1. Named Ranges (I used NumberRng) in the VBA code.
2. Events in VBA (I used a Change event so when you changed a number the code would be run)
3. If Then statements in VBA (I used the If Not Intersect ....)
4. Intersection of Ranges (Used in #3 above)
5. For Next Loops in VBA (Used to calculate and fill in the other non input numbers)
6. Application.EnableEvents to not go into an endless loop in VBA when it calculated the remaning numbers
7. Passing parameters to Event code (Used with the Target variable passed by Value, not by Ref)

I could go on but the bottom line is you need to know a lot of stuff to do what you want. As the problem changes you need to see what part of the code needs changing or develope a new plan to solve the problem. You asked a problem that needs your learning to solve. If you really want to get your answer and modify it, start learning the above.

Hi defeater,

The point was you need to learn lots more to attack your problem. Start by going through http://www.excel-vba.com/excel-vba-contents.htm

To see the VBA window try Alt-F11 (sorry, I don't know how to get there using the Mac 2011 version).

I wanted to show you that your question had an answer that worked. The problem is that you need to get better at Excel and VBA to understand or do the answer yourself. Hopefully in giving you the code (if you can find it) will show you things your need to learn.