Escanaba
asked on
Excel 2007 VB or Formula for List and Corresponding Text
Hello,
Hoping someone can assist in developing either a macro or a formula which looks at a drop-down list in Column A2 in the attached sample and will display all related text in column R associated with that selection starting at column B2. For example, if selection 1 is selected from the list, starting at column B2 down it should read ABC, DEF, HIJ, DEF.
Any assistance would be greatly appreciated.
Thanks!
EE-Example.xlsx
Hoping someone can assist in developing either a macro or a formula which looks at a drop-down list in Column A2 in the attached sample and will display all related text in column R associated with that selection starting at column B2. For example, if selection 1 is selected from the list, starting at column B2 down it should read ABC, DEF, HIJ, DEF.
Any assistance would be greatly appreciated.
Thanks!
EE-Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you....the selection results going down column B was what I was looking for and this does the trick!
you can alway use ActiveX combo and event driven macros too to do this.
i did produce and example of that, but you have already accepted a solution.
ActiveX combo and a macro, which is not as simple to create in the first instance, but will give you more power and flexability in a coded solution utlimatley.
i did produce and example of that, but you have already accepted a solution.
ActiveX combo and a macro, which is not as simple to create in the first instance, but will give you more power and flexability in a coded solution utlimatley.
i liked your solution Phillip Burton
Just incase anyone is interested in a alternative coded solution, and seeing as i had already done it, here is the solution i created.
EE-Example.xlsm
EE-Example.xlsm
Glen - this spreadsheet does not work in excel 2013 for some reason
The drop down box does not activate
The drop down box does not activate
EE-Example.xlsm