OK.. this might be hard, but here it goes..
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?
In a way, this is trying to become a type of program so that a person can select the model (with the price changes) and have it stand alone on the final page to eventually be transfered to word as a document for a contract.
Bookmarks