I tried what you suggested.. if you paste the formula itself and not the
value, the numbers in all three cells become the same each time you
click a different option (when I want the different result from
clicking each buttons showing in H11,12,13).

H28 is a reference point for those option buttons (Format Control
Control), so 1 is returned if the first one is selected, 2 for the
second.. etc. Other cells in the sheet (which I didn't include in that
dummy file) use it in an If statement to decide what values should be
used in calculations that reach the value in B6. For example: A column
has multiple rows with "if beech (H28=1) is selected then cell x should
be $5, if rimu (H28=3), x should be $7" and so on. Then B1 links to the
total of that column, which in turn affects B6.

Hope that makes sense!


--
sneakyzeal
------------------------------------------------------------------------
sneakyzeal's Profile: http://www.excelforum.com/member.php...o&userid=26978
View this thread: http://www.excelforum.com/showthread...hreadid=401901