A Search Engine inside Excel Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have this huge 800+ names on one spreasheet in excel. The problem I have
right now is that when a member calls me, I have to look all the way from top
to bottom. I cant have the names alphabetically orgonized because i have
everybody by numbers too, and thats what counts. The problem with that is
that all the members just give me their last name and its a mess. Can
someone tell me how to make a cell that if they call me I can start typing
and the cells below that will start moving depending on the letter I'm
typing? Like an active search engine but inside a spreadsheet?
Thank You, hope this makes sence!!!
 
Have you tried using an Autofilter on the namelist? It wwill work fo
up to 1000 entries.

---GJ
 
Autofilter will work for more than 1000 unique entries. But the list under the
dropdown is limited to 1000 unique entries. You can use a custom filter and
type in the value, though.
 

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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
merging spreadsheet data 1
Access Microsoft access database(creating a search engine form) 0
emailing from existing spreadsheet 3
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
Opening excel 2010 spreadsheet from Access 4
Search Box 4
Excel JUMP FROM SEARCH BAR TO RESULT 3

Back
Top