Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

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
0
Escanaba
Asked:
Escanaba
1 Solution
 
ProfessorJimJamCommented:
please find attached.
EE-Example.xlsm
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Please find attached.
EE-Example141031.xlsx
0
 
EscanabaAuthor Commented:
Thank you....the selection results going down column B was what I was looking for and this does the trick!
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Glen RichmondCustomer Reporting Programmer.Commented:
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.
0
 
ProfessorJimJamCommented:
i liked your solution Phillip Burton
0
 
Glen RichmondCustomer Reporting Programmer.Commented:
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
0
 
doctorbillCommented:
Glen - this spreadsheet does not work in excel 2013 for some reason
The drop down box does not activate
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now