Fill sequence down cells

G

gavmer

Hello,

I am in need of some brilliance. I am creating a pricing schedul
within excel and need to simplify the access of information. Imagine
base machine....R700. This machine has around 60 options to ad
however, each option has 11 pricing possibilities, depending on th
configuration( R701, R702, R703.....) . These 11 options are liste
individually next to the option on a pricing sheet, to be displayed o
a quoting sheet. When the configuration is ditermined, the same metho
of pricing applies to each option (IE if R702 is selected then pricin
for all the options would be the R702 price. What i am hoping for wa
a user selecting the configuration in the beginning.......th
corresponding price for each option of that configuration fills i
cells next to the option for selection. As an idea:

Select machine: (COmbo box??)
R701
R702
R703....ETC.

Then the pricing fills down rows 3,5,7,9...etc next to the option

OPTION 1: Price for selected spec(11 pricing options)

OPTION 2: Price for selected spec (11 pricing options)

Basically, a user selects R702, all the options show (in column D) th
pricing for that option on a R702. There is a row inbetween eac
option.

Can someone PLEASE show a stroke of brilliance and give an idea??

Thank you very much!!
 
Top