HELP...CLUELESS...

G

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. 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?
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

STILL NEED HELP.... 4
Need Help, Please 2
Seperating values 3
Three Conditions in one cell 5
Sumproduct Column B based on Column A 3
Drop Down Lists 2
Dropdown Menu? 5
using pivot table 3

Top