I would like to use a pull down menu to control the formulas in different
cells. For example if the pulldown is set to A then the formula in cells
are one thing. If set to B then the formula in that cell would change to
something else. I have though of using if statements, but this gets messy.
Do I need to get in to macro writing? I am looking for something simple.
Cheers