Pull Down List Filter

[IntricateFool]

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....

 

[Von Pookie]

What you want to do is *exactly* what autofilter is for. Why make it harder than it needs to be?

 

[IntricateFool]

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

 

[Aladin Akyurek]

Re: 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

See the formula system I describe in:

http://www.mrexcel.com/board2/viewtopic.php?t=176318

 

[IntricateFool]

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

 

[Von Pookie]

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?