Solved

Excel Macro List

Posted on 2013-01-22
10
230 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
  • 6
  • 4
10 Comments
 
LVL 29

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 29

Expert Comment

by:gowflow
ID: 38811412
I am confused what row are you talking about ? row 4 or row 11 ???
0
 

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 29

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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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 29

Accepted Solution

by:
gowflow earned 500 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 29

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 29

Expert Comment

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

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

758 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now