Ok this is a little hard to explain. I have a sheet with calculations on
it, and three radio buttons to click in order to change the values in
the cells (and result in a different answer "Selling Price"). Problem
is, on another sheet I have a list of "Products", with a row for each
type of product. For example:

First sheet is for Product A, made of wood, metal and plastic (radio
buttons 1, 2 and 3). Second sheet has a list of prices for Product A
wood, Product A metal and Product A plastic. Then there's a third sheet
for Product B wood, metal, plastic and so on..

I can't find a way to link the 3 different selling prices in the first
sheet to the list in the second sheet properly, as they end up in the
same cell and are only changed by the radio buttons. I've sort of been
able to separate them out, except the issue is that if you click on
option 1, then change a variable, it doesn't update the result in the
second sheet until you click on option 1 again.

I've spent forever on this and can't find a solution.. this is the last
resort!

Anyone have any ideas? Hopefully I've explained it clearly enough..

Thanks so much.


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