solving a matrix

[johannes2008]

Hello All

what I am trying to solve is this: In column A is the individual length of each section. In column B is the cumulative length. What I would like is for the user to enter either the section length or cumulative length for each row and then the code will fill in the missing values.

Any thoughts? the only way I can think of that will take care of all contingencies involves writing "if" statements for each conceivable circumstance.

Thanks
-Johannes

 

[shg]

To do it without VBA, you'd need to do data entry in two columns (A & B) and calculations in two other columns (C & D). The formulas would have to prioritize section length vs cum length, and use one or the other.

Some conditional formatting in cols A & B (obscuring the lower priority cell if there were an entry in the higher priority cell) would make clear to the user which value is being used.

 

[johannes2008]

Thanks shg for your reply. I am actually wanting to do it with VBA. But the only way I can think of is by writing numerous if statements.

Thanks
-Johannes