Drop Down Lists

[catc1]

I am fairly new to excel.
I am trying to put together a quotation worksheet for a friend but am having great difficulties. I am creating a quotation spreadsheet, what my friend would like is, through a drop down list to be able to click on a name in that drop down list and for that name to be linked with specific prices. Every name has a different set of prices and therefore cannot be calculated off the same sheet. Here is an example of the price list of one of the names IVORY BROWN
THE QUESTION IS HOW TO CREATE A SPREADSHEET THAT USES THE DROP DOWN LIST TO ACTIVATE A NEW SET OF PRICES FOR THE SELECTED NAME?

Material: Ivory Brown Date


30mm Granite Required Polishing Required

Length Width Total M² Edge Detail Qty Mts Cost
0 Square £0.00
0 ½ Round £0.00
0 Full Round £0.00
0 Total: £0.00
0
0 Cut Outs Required
0
0 Type Qty Cost
Total M²: 0 Sink Polished £0.00
Sink Unpolished £0.00
20mm Granite Required Belfast Sink £0.00
Drainer Grooves £0.00
Length Width Total M² Tap Hole £0.00
0 Hob Cut Out £0.00
0 Radius Ends £0.00
0 Total: £0.00
0

[catc1]

I am fairly new to excel.
I am trying to put together a quotation worksheet for a friend but am having great difficulties. I am creating a quotation spreadsheet, what my friend would like is, through a drop down list to be able to click on a name in that drop down list and for that name to be linked with specific prices. Every name has a different set of prices and therefore cannot be calculated off the same sheet. Here is an example of the price list of one of the names IVORY BROWN
THE QUESTION IS HOW TO CREATE A SPREADSHEET THAT USES THE DROP DOWN LIST TO ACTIVATE A NEW SET OF PRICES FOR THE SELECTED NAME?


Material: Ivory Brown 282.5875 Date


30mm Granite Required Polishing Required

Length Width Total M² Edge Detail Qty Mts Cost
0 Square £0.00
0 ½ Round £0.00
0 Full Round £0.00
0 Total: £0.00
0
0 Cut Outs Required
0
0 Type Qty Cost
Total M²: 0 Sink Polished £0.00
Sink Unpolished £0.00
20mm Granite Required Belfast Sink £0.00
Drainer Grooves £0.00
Length Width Total M² Tap Hole £0.00
0 Hob Cut Out £0.00
0 Radius Ends £0.00
0 Total: £0.00
0

[catc1]

I am fairly new to excel.
I am trying to put together a quotation worksheet for a friend but am having great difficulties. I am creating a quotation spreadsheet, what my friend would like is, through a drop down list to be able to click on a name in that drop down list and for that name to be linked with specific prices. Every name has a different set of prices and therefore cannot be calculated off the same sheet. Here is an example of the price list of one of the names IVORY BROWN
THE QUESTION IS HOW TO CREATE A SPREADSHEET THAT USES THE DROP DOWN LIST TO ACTIVATE A NEW SET OF PRICES FOR THE SELECTED NAME?

Material: Ivory Brown Date


30mm Granite Required Polishing Required

Length Width Total M² Edge Detail Qty Mts Cost
0 Square £0.00
0 ½ Round £0.00
0 Full Round £0.00
0 Total: £0.00
0
0 Cut Outs Required
0
0 Type Qty Cost
Total M²: 0 Sink Polished £0.00
Sink Unpolished


20mm Granite Required Belfast Sink £0.00
Drainer Grooves £0.00
Length Width Total M² Tap Hole £0.00
0 Hob Cut Out £0.00
0 Radius Ends £0.00
0 Total: £0.00
0
Total M²: 0 Items Cost
30mm Granite £0.00
Upstands 100mm Max 20mm Granite £0.00
Length Cost Edge Polishing £0.00
£0.00 Cutouts £0.00
Sub Total £0.00
Deposit Required at order: £225.00 Installation £450.00
Balance due on completion: £225.00 Grand Total * £450.00

[catc1]

I am fairly new to excel.
I am trying to put together a quotation worksheet for a friend but am having great difficulties. I am creating a quotation spreadsheet, what my friend would like is, through a drop down list to be able to click on a name in that drop down list and for that name to be linked with specific prices. Every name has a different set of prices and therefore cannot be calculated off the same sheet. Here is an example of the price list of one of the names IVORY BROWN
THE QUESTION IS HOW TO CREATE A SPREADSHEET THAT USES THE DROP DOWN LIST TO ACTIVATE A NEW SET OF PRICES FOR THE SELECTED NAME?

Material: Ivory Brown Date


30mm Granite Required Polishing Required

Length Width Total M² Edge Detail Qty Mts Cost
0 Square £0.00
0 ½ Round £0.00
0 Full Round £0.00
0 Total: £0.00
0
0 Cut Outs Required
0
0 Type Qty Cost
Total M²: 0 Sink Polished £0.00
Sink Unpolished


20mm Granite Required Belfast Sink £0.00
Drainer Grooves £0.00
Length Width Total M² Tap Hole £0.00
0 Hob Cut Out £0.00
0 Radius Ends £0.00
0 Total: £0.00
0
Total M²: 0 Items Cost

30mm Granite £0.00
Upstands 100mm Max 20mm Granite £0.00
Length Cost Edge Polishing £0.00
£0.00 Cutouts £0.00
Sub Total £0.00
Deposit Required at order: £225.00 Installation £450.00
Balance due on completion: £225.00 Grand Total * £450.00

[sweep]

Take a look here

http://www.contextures.com/xlDataVal02.html

[royUK]

Welcome to the Forum. Please take the time to read the Forum Rules, your Title should not include unnecessary words like "Please help". This makes the Forum Search Engine more efficient.

To give us an idea of what you are doing attach a zipped example workbook.

[royUK]

I really suggest that you spend a few minutes reading the Forum Rules. I have already edited this post in another sub forum because the title breaks the rules, now I find you posting in multiple forums which again breaks the rules.


See
http://www.excelforum.com/showthread...79#post1891479

[royUK]

catc1

READ THE RULES!!!!!

I have hidden the reply from Ed until you acknowledge that you will follow the Rules!

[royUK]

catc1, you are completely ignoring the Rules - four posts of this question in as many forums. I have locked them until you acknowledge that you will follow the rules in future.

Sweep, I have hidden your reply until catc1 decides to follow the Rules.

See
http://www.excelforum.com/showthread...79#post1891479

[catc1]

I am fairly new to excel.
I am trying to put together a quotation worksheet for a friend but am having great difficulties. I am creating a quotation spreadsheet, what my friend would like is, through a drop down list to be able to click on a name in that drop down list and for that name to be linked with specific prices. Every name has a different set of prices and therefore cannot be calculated off the same sheet. Here is an example of the price list of one of the names IVORY BROWN
THE QUESTION IS HOW TO CREATE A SPREADSHEET THAT USES THE DROP DOWN LIST TO ACTIVATE A NEW SET OF PRICES FOR THE SELECTED NAME?

Material: Ivory Brown Date


30mm Granite Required Polishing Required

Length Width Total M² Edge Detail Qty Mts Cost
0 Square £0.00
0 ½ Round £0.00
0 Full Round £0.00
0 Total: £0.00
0
0 Cut Outs Required
0
0 Type Qty Cost
Total M²: 0 Sink Polished £0.00
Sink Unpolished


20mm Granite Required Belfast Sink £0.00
Drainer Grooves £0.00
Length Width Total M² Tap Hole £0.00
0 Hob Cut Out £0.00
0 Radius Ends £0.00
0 Total: £0.00
0
Total M²: 0 Items Cost

30mm Granite £0.00
Upstands 100mm Max 20mm Granite £0.00
Length Cost Edge Polishing £0.00
£0.00 Cutouts £0.00
Sub Total £0.00
Deposit Required at order: £225.00 Installation £450.00
Balance due on completion: £225.00 Grand Total * £450.00

[catc1]

Drop Down Lists

--------------------------------------------------------------------------------

I am fairly new to excel.
I am trying to put together a quotation worksheet for a friend but am having great difficulties. I am creating a quotation spreadsheet, what my friend would like is, through a drop down list to be able to click on a name in that drop down list and for that name to be linked with specific prices. Every name has a different set of prices and therefore cannot be calculated off the same sheet. Here is an example of the price list of one of the names IVORY BROWN
THE QUESTION IS HOW TO CREATE A SPREADSHEET THAT USES THE DROP DOWN LIST TO ACTIVATE A NEW SET OF PRICES FOR THE SELECTED NAME?

Material: Ivory Brown Date


30mm Granite Required Polishing Required

Length Width Total M² Edge Detail Qty Mts Cost
0 Square £0.00
0 ½ Round £0.00
0 Full Round £0.00
0 Total: £0.00
0
0 Cut Outs Required
0
0 Type Qty Cost
Total M²: 0 Sink Polished £0.00
Sink Unpolished


20mm Granite Required Belfast Sink £0.00
Drainer Grooves £0.00
Length Width Total M² Tap Hole £0.00
0 Hob Cut Out £0.00
0 Radius Ends £0.00
0 Total: £0.00
0
Total M²: 0 Items Cost

30mm Granite £0.00
Upstands 100mm Max 20mm Granite £0.00
Length Cost Edge Polishing £0.00
£0.00 Cutouts £0.00
Sub Total £0.00
Deposit Required at order: £225.00 Installation £450.00
Balance due on completion: £225.00 Grand Total * £450.00

[catc1]

Drop Down Lists

--------------------------------------------------------------------------------

I am fairly new to excel.
I am trying to put together a quotation worksheet for a friend but am having great difficulties. I am creating a quotation spreadsheet, what my friend would like is, through a drop down list to be able to click on a name in that drop down list and for that name to be linked with specific prices. Every name has a different set of prices and therefore cannot be calculated off the same sheet. Here is an example of the price list of one of the names IVORY BROWN
THE QUESTION IS HOW TO CREATE A SPREADSHEET THAT USES THE DROP DOWN LIST TO ACTIVATE A NEW SET OF PRICES FOR THE SELECTED NAME?

Material: Ivory Brown Date


30mm Granite Required Polishing Required

Length Width Total M² Edge Detail Qty Mts Cost
0 Square £0.00
0 ½ Round £0.00
0 Full Round £0.00
0 Total: £0.00
0
0 Cut Outs Required
0
0 Type Qty Cost
Total M²: 0 Sink Polished £0.00
Sink Unpolished


20mm Granite Required Belfast Sink £0.00
Drainer Grooves £0.00
Length Width Total M² Tap Hole £0.00
0 Hob Cut Out £0.00
0 Radius Ends £0.00
0 Total: £0.00
0
Total M²: 0 Items Cost

30mm Granite £0.00
Upstands 100mm Max 20mm Granite £0.00
Length Cost Edge Polishing £0.00
£0.00 Cutouts £0.00
Sub Total £0.00
Deposit Required at order: £225.00 Installation £450.00
Balance due on completion: £225.00 Grand Total * £450.00

[darkyam]

You can actually use a VLOOKUP for this. In your lookup arrray, have each name and then the actual item (e.g., IVORY BROWN Square) in column 1 and the price in column 2. If your dropdown cell is A1 and Square is in A2, B2 (the price) could have =VLOOKUP(A$1&" "&A2,<data array>,2,False). Then you can drag that formula down. Another option is the Index/Match method, which takes the data array out to the right rather than down, but essentially accomplishes the same thing.

[catc1]

My problem is
I have 50 diferent types of marble, they all fall into different price groups, in each price group, i need to calculate sqm price , upstands etc, so i am using the sum functions to calculate all the measurements etc
This is fine if i am using one price group.
What i want to do, is to click on a drop down list of all the 50 marbles on ONE worksheet and to be able to go and calculate the prices for that marble.
I have all the seperate price lists for the marbles on different worksheets, How can i combine them?

I hope i am making sense.
If you can help, do you think this is a big project for someone with very little excel experience?

I have attached an example.
I want to use the same sheet for each marble group, but in each sheet there will be different calculations for different prices .


Granite Quotation Customer:
Tel: Ref no:
Fax: Address:
Salesman:
Email: sales Post Code:
Address:




Material: Absolute Black Date

30mm Granite or Quartz Required
Length Width Total M² Polishing Required
0 Edge Detail Qty Mts Cost
0
0 Double Bevel £0.00
0 Pencil £0.00
0 30-100mm built up edge £0.00
0
0 Total: £0.00
0
Total M²: 0 Cut Outs Required
Type Qty Cost
20mm Granite Required Polished cut out £0.00
Length Width Total M² Unploished cut out £0.00
0 Set of grooves £0.00
0 Tap Hole £0.00
0 RadiusCorners £0.00
0 up to 100mm
Total M²: 0 Full Arch £0.00
Recessed Drainers
Flushline Hob
Total: £0.00

Upstands 100mm high
Length Cost Items Cost
Length Cost 30mm Granite £0.00
£0.00 20mm Granite £0.00
Edge Polishing £0.00
Cutouts £0.00
Sub Total £0.00
Installation £00.00
Balance due on completion: Grand Total £000.00

[royUK]

There is no attachment, you must zip the file.

[royUK]

How many times have you posted your other question on Drop Down lists?

I've just checked, you have asked it 7 times in different sub forums. DON'T WASTE MEMBERS' TIME LIKE THIS. READ THE RULES