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!

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


--
Gary''s Student
gsnu200706


"Thad" wrote:

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!

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!



"Gary''s Student" wrote:

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


--
Gary''s Student
gsnu200706


"Thad" wrote:

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!