[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Excel Macro List

Posted on 2013-01-22
10
Medium Priority
?
239 Views
Last Modified: 2013-01-24
Hi, I have this vlookup code, but I want to be able to pull a list by age etc with a macro. Please let me know how I could accomplish this? Thanks!!
TestMacro1.xlsm
0
Comment
Question by:jquestion
[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
  • 6
  • 4
10 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 38810082
Let me get this correctly.
You need dropdown in B for uniques and then dropdown in C for their uniqes etc ... D,E and Fis that what you want ?

Like in B  you would have
1
2
3
if you choose 1 in B then in C you would have
a
d
g
j
m
to choose from etc.. is that what you want ?
gowflow
0
 

Author Comment

by:jquestion
ID: 38810394
The first drop down is fine. I want it as a stand alone.


the second dropdown under age:
Say there are 5 people that are 20 years old.
I want to select 20 in the drop down then I want  to display all 5 people's data rows listed.

I hope this makes sense, thanks!!!
0
 
LVL 31

Expert Comment

by:gowflow
ID: 38811412
I am confused what row are you talking about ? row 4 or row 11 ???
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.

 

Author Comment

by:jquestion
ID: 38811561
Hi, sorry.

I want to leave row 4 alone and its macro alone.


row 11 i want to create the new macro to display the list


Thanks!
0
 
LVL 31

Expert Comment

by:gowflow
ID: 38812152
So in row 11 you type or choose an age and you want it to display all the records that have this age for all the columns is that right ?
gowflow
0
 

Author Comment

by:jquestion
ID: 38812177
Hi,  yes id like a dropdown for age and want to be able to display all records with that age. I appreciate your help!
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 38812470
ok check this file select an item from the yellow cell and check the result. We can streamline Cell C11 to also show unique but you have not requested that so I left them as is.

Let me know
gowflow
TestMacro1.xlsm
0
 
LVL 31

Expert Comment

by:gowflow
ID: 38813400
Have you tested the macro ? Is it what you wanted ? pls let me know we can cater it to your needs.
gowflow
0
 

Author Closing Comment

by:jquestion
ID: 38814877
Works perfect, thanks!
0
 
LVL 31

Expert Comment

by:gowflow
ID: 38815089
glad we could help.
gowflow
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

656 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