View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
E10 E10 is offline
external usenet poster
 
Posts: 14
Default HELP...CLUELESS...

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?