I am trying to build a spreadsheet that, by selection from a series of Option
Buttons, populates a formula to generate the anticipated output.
Specifically, I want values for items (listed at Option Buttons) to be
multiplied by another cell value. The value of the Option Button also varies
so I want it to be editable from a schedule of values (SOV)of sorts as a
separate page on the same spreadsheet that I can easily update periodically.
This way, if I change the value in my SOV and I select my Option Button on a
different page, my output will represent the value of the variable changed on
my SOV and by the value of the aforementioned cell that will be multiplied in
the formula.

Confusing enough? ;)

Thanks in advance for any help.