Pull Down List Filter

I

IntricateFool

New Member
Joined
Nov 3, 2005
Messages
11
I need to design a pull down list that when choosing a particular name only shows results for that particular person. I do not want to use an auto or advanced filter. This is for unexperienced excel users to come in to a worksheet and choose their name from a pull down box and then display the results for their name.

Example:
Drop Box Would Be... [Debbie]v Where debbie would be the first one in the list. When you choos Debbie from the list excel displays only the 3 debbie rows. And the same for George, Ryan or Scott.
I'm just assuming there is a way to do this without VBA. Just please steer me in the right direction

Name | Account | Company
Debbie | 656775 | Amerigroup
Debbie | "........." | "............."
Debbie | "........." | "............"
George | ".........." | "............" { This is all corresponding data
George | "........." | "............" use your imagination that this is
George |"........." | "............" an excel spreadsheet
Ryan | ".........." | "............"
Ryan | ".........." | "............"
Scott | ".........." | "............"
Scott | ".........." | "............"
Scott | ".........." | "............"
Scott | ".........." | "............"


Thanks For Your Help....
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
What you want to do is *exactly* what autofilter is for. Why make it harder than it needs to be? :huh:
 
Upvote 0
I know that's what AutoFilter does

the problem with autofilter is that I need people to use this spreadsheet that have never used excel before. Yeah I realize though autofilter would be the easiest way, but I know there is some way to do it with a pull down
 
Upvote 0
Pull Down FIlter Using VBA

I am trying so hard to figure this one out. Seems so easy yet nobody seems to know. Hope one of you do...

Trying to create a pull down box with a list of names from a workbook. Basically the same as the autofilter but I need users who have never used excel before to come in the workbook and choose their name and the corresponding information associated with their name will be shown. In other words Kevin Williams for example will have 5 entries and Mary Gucci will have 6 entries, etc, etc. From the pull down if Kevin were to choose Kevin Williams from the pull down it will auto filter out his names' entries. For the most part have a workbook function as a database. Are there any tutorials for this online or can someone send me in the right direction? Thanks
 
Upvote 0
Honestly, I still can't see why autofilter won't work, here.

You want to make it for users who have never used Excel, yet instead of using the built-in feature that does exactly what you're wanting to do, you want to do the exact same thing with code.

Frankly, code can cause more problems than it's probably worth. Other than the little things that can cause the code to error out here and there, there is also the possibility of the users having different versions of Excel--the code may not even be able to run on their computer, for example--you just don't know.

I'm not trying to harp on you or anything; I just honestly don't understand. What's the difference between having the user select a value from a dropdown list that the autofilter automatically created and one that you created manually? I would think it would be a lot easier to turn on autofilter and then explain how to click the dropdown arrow, etc. Either way, if they don't know anything about Excel you would have to explain it, anyway?

:huh:
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question Question
EXCEL VBA COMBO BOX/DROP DOWN LIST
Replies
1
Views
207
Peter_SSs
Peter_SSs
S
  • Solved
When Filter is applied, Excel jumps down multiple rows to (Blanks). How can Filter ignore blanks?
Replies
3
Views
473
Peter_SSs
Peter_SSs
G
  • Question Question
Curious Filter-by-formula issue
Replies
1
Views
103
gordonpsmith
G
S
  • Question Question
Excel Drop Down Multiple Select/Remove & Auto Alphabetize Selections
Replies
0
Views
306
Sactown Steve
S
D
  • Question Question
Choose from List Box
Replies
5
Views
187
ddnron
D

Forum statistics

Threads
1,224,878
Messages
6,181,527
Members
453,053
Latest member
DavidKele

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top