Need Help, Please

[Guest]

I need help setting up a drop-down list...I'm close to figuring it out, but
it still does not work the way I need it to. Here is what I need:

I have a list of several thousand cities in Column A (and there are several
blank cells in between the list of cities in Column A). I have information
in Column C that corresponds to the individual cities listed in Column A. I
want a drop-down list at the top of Column A that will allow me to select a
specific city, and once selected, will bring me to that individual city and
its corresponding info in Column C. Can someone please assit me? Thank you!

 

[Guest]

Definitely consider using AutoFilter. It can generate a pull-down (
alphbetic order) that will very rapidly allow you to get to the data of
interest.

see:

http://www.contextures.com/xlautofilter01.html

 

[Guest]

Thank you for the suggestion. Ok, so in Column A, I have a list of several
cities. In Column C, I have hospital names and right below the hospital
names, I have demograhic information. How can I customize the AutoFilter to
not include the demographic info and just keep the hopital names?


Thank you!