Hello,

I am trying to create a worksheet with many drop down lists tha
coincide with each other. I would like to have it where I have
machine drop down list, after selecting your machine, it will the
select the proper list of attachments to match with the machine. Wit
the attachment selection, I would need multiple lists to run from it.

Example, the machine selected, and a list of attacments would show
From there I would like to select all 4 attachments, each attachmen
would be selected from a drop down list. Then from each the machine
and the attachments, I would like a price to show up in anothe
column.

Machine
Wheel Loader $150,000
Attachments
quick coupler $4000
fork rack $8000
bucket $12000
grapple $17000

Any ideas?

Th

--
Browet
-----------------------------------------------------------------------
Browett's Profile: http://www.excelforum.com/member.php...fo&userid=3633
View this thread: http://www.excelforum.com/showthread.php?threadid=56124

See if this helps:

http://contextures.com/xlDataVal02.html

Biff

"Browett" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Hello,
>
> I am trying to create a worksheet with many drop down lists that
> coincide with each other. I would like to have it where I have a
> machine drop down list, after selecting your machine, it will then
> select the proper list of attachments to match with the machine. With
> the attachment selection, I would need multiple lists to run from it.
>
> Example, the machine selected, and a list of attacments would show.
> From there I would like to select all 4 attachments, each attachment
> would be selected from a drop down list. Then from each the machine,
> and the attachments, I would like a price to show up in another
> column.
>
> Machine
> Wheel Loader $150,000
> Attachments
> quick coupler $4000
> fork rack $8000
> bucket $12000
> grapple $17000
>
> Any ideas?
>
> Thx
>
>
> --
> Browett
> ------------------------------------------------------------------------
> Browett's Profile:
> http://www.excelforum.com/member.php...o&userid=36337
> View this thread: http://www.excelforum.com/showthread...hreadid=561245
>

For a solution that works with relational tables see
Cascading queries
http://www.tushar-mehta.com/excel/ne...wns/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <(E-Mail Removed)>,
(E-Mail Removed) says...
>
> Hello,
>
> I am trying to create a worksheet with many drop down lists that
> coincide with each other. I would like to have it where I have a
> machine drop down list, after selecting your machine, it will then
> select the proper list of attachments to match with the machine. With
> the attachment selection, I would need multiple lists to run from it.
>
> Example, the machine selected, and a list of attacments would show.
> From there I would like to select all 4 attachments, each attachment
> would be selected from a drop down list. Then from each the machine,
> and the attachments, I would like a price to show up in another
> column.
>
> Machine
> Wheel Loader $150,000
> Attachments
> quick coupler $4000
> fork rack $8000
> bucket $12000
> grapple $17000
>
> Any ideas?
>
> Thx
>
>
> --
> Browett
> ------------------------------------------------------------------------
> Browett's Profile: http://www.excelforum.com/member.php...o&userid=36337
> View this thread: http://www.excelforum.com/showthread...hreadid=561245
>
>