rcbricker
03-31-2005, 01:34 PM
Hiya guys here is an interesting one that will get more complicated as we go along.
I have a table (a matrix really) that I need to have a value gotten by comparing one value on the X axis to a value on the Y axis and having that value in the intersecting cell returned. lost yet? I will post and example. Once we have that worked out.
I need the values on the X and Y axis to be dependent on an outside value. Lets say from a second sheet (actually it will be a different workbook altogether).
The values will need to change based on an outside value that will be from 1-100. I have not figured out the results of what the change will be but figure I can define the changes after we figure out how to change them.:p
I have a table (a matrix really) that I need to have a value gotten by comparing one value on the X axis to a value on the Y axis and having that value in the intersecting cell returned. lost yet? I will post and example. Once we have that worked out.
I need the values on the X and Y axis to be dependent on an outside value. Lets say from a second sheet (actually it will be a different workbook altogether).
The values will need to change based on an outside value that will be from 1-100. I have not figured out the results of what the change will be but figure I can define the changes after we figure out how to change them.:p