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

Professor J

please find attached.
EE-Example.xlsm

ASKER CERTIFIED SOLUTION

Phillip Burton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Escanaba

ASKER

Thank you....the selection results going down column B was what I was looking for and this does the trick!

Glen Richmond

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.

Professor J

i liked your solution Phillip Burton

Glen Richmond

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

doctorbill

Glen - this spreadsheet does not work in excel 2013 for some reason
The drop down box does not activate