• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

Excel Macro List

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
jquestion
Asked:
jquestion
  • 6
  • 4
1 Solution
 
gowflowCommented:
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
 
jquestionAuthor Commented:
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
 
gowflowCommented:
I am confused what row are you talking about ? row 4 or row 11 ???
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
jquestionAuthor Commented:
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
 
gowflowCommented:
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
 
jquestionAuthor Commented:
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
 
gowflowCommented:
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
 
gowflowCommented:
Have you tested the macro ? Is it what you wanted ? pls let me know we can cater it to your needs.
gowflow
0
 
jquestionAuthor Commented:
Works perfect, thanks!
0
 
gowflowCommented:
glad we could help.
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

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