|
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 |
You could do this with programming to run an advanced filter when the
value in cell B4 is changed. There are some examples he http://www.contextures.com/excelfiles.html Under Filters, look for 'Product List by Category' 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
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 |
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. Thanks -- 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 |
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 |
see my email address above,remove the nospam infront of paradise
-- paul remove nospam for email addy! "torangel" wrote: 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 |
I could email you if i knew where!
-- paul remove nospam for email addy! "torangel" wrote: 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 |
| All times are GMT +1. The time now is 08:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com