G

#### Guest

I have three sheets: 1. with pricing information, 2. With an input section

(how many units and what not are placed into the respective cells) and 3. The

output.

On the first page, 5 different types of models are listed. Under each model

are pricing levels for each additional component added on to the base model

price. Each base model(the 5 different ones) have different pricing levels,

rendering there formulas to be similar and not similar at times.

I have created a drop down menu with each of the five models listed. Under

the menu is a database setup to calculate the price*the quanity of the

various components (i.e. base model, additional seats, service worker

fee,..etc.)

I am trying to have it so that each time I choose one of the models, the

pricing formulas below coordinate with the second page to create each total

price respectively, in each cell..therefore showing the choosen model (with

all the pricing information alone on the third page.

example:

Base model 1.

base fee= 1500 (because 1 model is requested, and they are 1500 per 1)

challenege price: 200...

and so forth.

I can get the formulas to work properly if I list each model at the same

time (in other words, all five models are listed in five separate columns)

I am trying to get it so that if someone choose one of the models on the

first or second page, it will be displayed by itself on the third.

Any help?