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

"paul" wrote:

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.
--
paul
remove nospam for email addy!



"Jim Johnson" wrote:


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.


--
Jim Johnson
------------------------------------------------------------------------
Jim Johnson's Profile: http://www.excelforum.com/member.php...nfo&userid=300
View this thread: http://www.excelforum.com/showthread...hreadid=384422