A Search Engine inside Excel Spreadsheet

E

Edgar

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!!!
 
G

gjcase

Have you tried using an Autofilter on the namelist? It wwill work fo
up to 1000 entries.

---GJ
 
D

Dave Peterson

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.
 
Top