jquestion
asked on
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
TestMacro1.xlsm
ASKER
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!!!
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!!!
I am confused what row are you talking about ? row 4 or row 11 ???
ASKER
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!
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!
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
gowflow
ASKER
Hi, yes id like a dropdown for age and want to be able to display all records with that age. I appreciate your help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have you tested the macro ? Is it what you wanted ? pls let me know we can cater it to your needs.
gowflow
gowflow
ASKER
Works perfect, thanks!
glad we could help.
gowflow
gowflow
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