View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Confused at Work Confused at Work is offline
external usenet poster
 
Posts: 26
Default Creating a Search

Just wondering I have a list of Customers from A1 to A500 Column 1 with all
addresses and information hyperlinked to a seperate worksheet. Instead of
going through each one and scrolling down in alphabetical order is there a
way at the top of the page to have a search cell, where I just type in the
first 5 to six letters and the information comes up and I click on it and it
then takes me to their customer information?

Thanks for your help.