?
Solved

Excel 2007 VB or Formula for List and Corresponding Text

Posted on 2014-10-31
7
Medium Priority
?
292 Views
Last Modified: 2014-12-28
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
Comment
Question by:Escanaba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40415934
please find attached.
EE-Example.xlsm
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 2000 total points
ID: 40415948
Please find attached.
EE-Example141031.xlsx
0
 
LVL 1

Author Closing Comment

by:Escanaba
ID: 40416010
Thank you....the selection results going down column B was what I was looking for and this does the trick!
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 2

Expert Comment

by:Glen Richmond
ID: 40416044
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
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40416178
i liked your solution Phillip Burton
0
 
LVL 2

Expert Comment

by:Glen Richmond
ID: 40419133
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
 

Expert Comment

by:doctorbill
ID: 40520887
Glen - this spreadsheet does not work in excel 2013 for some reason
The drop down box does not activate
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question