Drop down lists

[Jim Johnson]

I have a worksheet that I want to enter a drop down list. When a
selection is made I want the sheet to be populated with a list of
actions that are unique to that particular entry in the drop down list.
The entries in the dropdown list would be "Orifice Plate, Guides, Disc,
Stem, Bolting etc." As an example; if the word Disc was chosen from the
list in Cell B4 Cells b6 thru b28 would be populated with following
PER COMPUTER
HARDFACING
HARDFACING
SQ FT REFRAC.
SQ FT HEX MESH
CORNER TABS
SPACER BAR


PRESS
HBM
OVERLAY
INST HEX PT RET
PRESS
STRESS
SANDBLAST
INSTALL REFRACTORY
CURE
FINISH GRIND
DEBURR
COLDSET

Similar descriptions would be inserted for Guides etc. Any help would
be appreciated.

 

[Debra Dalgleish]

You could do this with programming to run an advanced filter when the
value in cell B4 is changed. There are some examples here:

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

Under Filters, look for 'Product List by Category'

 

[Guest]

Jim I have done this with a drop down box from the form toolbar and a vlookup
table.
Basically you have your list of orifice plates etc as your list in the
dropdown box,and you use =vlookup( and match to populate your resulting
list.I can send you a sample sheet if you like.Send me an email(my email
address is in my profile (modify as shown)and i will reply with an
attatchment.

 

[Jim Johnson]

This sounds like what I am looking for but I cannot get to your profile
Go into my profile and send me the example if you would.

Thank

 

[Guest]

Hi Paul

This sounds like exactly what I have been looking for. I tried to email you
to see if you would send me the sample sheets but the message was returned as
undeliverable. Could you email me?

Thanks

Karen

 

[Guest]

(e-mail address removed)

 

[Guest]

see my email address above,remove the nospam infront of paradise

 

[Guest]

I could email you if i knew where!