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. 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. Is there a way I can customize some
sort of filter to not include the demographic info and just keep the hopital
names?

Data---Filter---Autofilter

"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. 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. Is there a way I can customize some
sort of filter to not include the demographic info and just keep the hopital
names?

Data Filer Autofilter will not work for my C column because it includes
all the demographic information in the drop down box. How can I cusomize it
to only show the Hospital names?




"E10" wrote:

Data---Filter---Autofilter

"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. 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. Is there a way I can customize some
sort of filter to not include the demographic info and just keep the hopital
names?