I was asked by a coworker if this is possible, but I cannot find a way to get around a circular reference problem.
Simplest example I can think of is this: Let's say you have three related values such as radius, diameter and circumference. Is it possible to have three cells with these values so that as I change any one of them the other two will update to the correct related values?
I tried scenario analysis, vlookup, if-then... nothing. Any help is GREATLY APPRECIATED. If there is a simple VB answer, I would welcome it. I have used VB in Access but never in Excel, so the chance to write my first VB code in Excel would be a good thing... as long as it is simple enough for me to understand and explain to my coworker.
THANKS!!!
Simplest example I can think of is this: Let's say you have three related values such as radius, diameter and circumference. Is it possible to have three cells with these values so that as I change any one of them the other two will update to the correct related values?
I tried scenario analysis, vlookup, if-then... nothing. Any help is GREATLY APPRECIATED. If there is a simple VB answer, I would welcome it. I have used VB in Access but never in Excel, so the chance to write my first VB code in Excel would be a good thing... as long as it is simple enough for me to understand and explain to my coworker.
THANKS!!!