Excel question... can it write a program on more than two axis?

Question

I know how to write program to the side and down.. but can a single cell do a complex program somehow? I'm thinking excel isn't advanced enough to do this... but if it is I definitely don't know how and would appreciate some assistance in figuring out how to do this. To make this a little more understandable let me give you and example.. It may take more than the characters I have left so look for additional details if you open this question soon.

This is what the program I was originally asked to write looks like basically.

Code # Units total: Units used: Units remaining: Money Remaining:


There are about 20 different codes.. and they decided they, instead of having a sheet per child, would like all the names on the verticle axis and keep all this info and list it per child... now to do that on the horizontal axis with so many codes, and so much information about Each Code # would make the sheet about 100 cells long on the horizontal axis.

I convinced them that wasn't practical to work with.. but what I need to know is basically this.. I have program written into that do the simple math for each Code # as I listed:


Code # Units total: Units used: Units remaining: Money Remaining:

Is there any way that I could make an INDIVIDUAL cell be able to reference those programs.... say make it expandable to be able to include and edit those original programs... all inside one cell?

I think I'm asking way too much of Excel.. but before I told them it can't be done on this program I thought I'd ask.

It's hard to explain and make it make sense I think... if these all sounds like gibberish and you need to see it.. I have no problem emailing you a copy of the program as well as a model of how they would like it (if possible)

Answer 1

Hi,

You might try posting this question in the excel newsgroups on usenet. Click the links below for a way to get there.

-Jim Gordon
Microsoft Mac MVP

MVPs are independent and do not work for Microsoft
http://mvp.support.microsoft.com/

Answer 2

you're right, it is a little difficult to follow what you're saying, but I get the feeling that what you're needing to do is to have to individual data for each person on a separate sheet, or section, and then have the main sheet be a summary of all the information tallied in the child tables. That way you can perform the calculations on a per child basis.