| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Drop down lists
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Symbols in Drop Down Lists | Excel Worksheet Functions | |||
| Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
| multiple drop down lists | Excel Discussion (Misc queries) | |||
| Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) | |||
| How do I change the appearance of my drop down lists? | Excel Worksheet Functions | |||
Threaded Mode
