Drop down list for Data retrieval
Hi all !
I have a request, but I'm not quite sure how to word it in order to search for it !
Basically I have a list of similar data, and I'd like to put an arrow on the row heading that just groups it so for instance:
Name City
Jessie Paris
Dave London
Kim Paris
Katie London
I'd like a drop down list by City that has the selections Paris and London and when I select either one, I get all the names that go under either one.
I looked up drop down list but that was more for data entry...I saw something on Forms, but when I created that, on the drop down list it gave me all the entries already there in full (so that when I selected the drop down arrow it just gave me Parris, London, Paris, London, instead of just Paris, London).
would really appreciate some help in the right direction...
Thank you all !!
tiny dancer
Last edited by tiny_dancer; 01-10-2011 at 08:52 AM.
Using Autofilter is no good for you then?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you Mr Domski that worked perfect !Originally Posted by Domski
Sorry for the bother, I knew what I wanted I just didn't know the term for it.
Finally, do you know how I could get totals? so for instance lets say I select Paris, how could I make it so that a numebr shows up that shows all people in Paris.
Have a look at the SUBTOTAL worksheet function. It has functions for ignoring hidden values which should work as you describe.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks