| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Automatically search to row in a column
I have a spreadsheet set up with a huge list of names, is there a way to
"lock it" and be able to start typing a name, say in the first row and have it take me right to the correct row with the name? With out using the "edit --find feature" which i find very time consumming to use every time I need to get to a different name. Using excel 2002 Thx |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Automatically search to row in a column
You could use a worksheet_change event to do this. However, you would wait
until all of the name is in. -- Don Guillett SalesAid Software "Mex" wrote in message ... I have a spreadsheet set up with a huge list of names, is there a way to "lock it" and be able to start typing a name, say in the first row and have it take me right to the correct row with the name? With out using the "edit --find feature" which i find very time consumming to use every time I need to get to a different name. Using excel 2002 Thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| how do I search a colum for duplicates automatically | Excel Discussion (Misc queries) | |||
| two column search | Excel Discussion (Misc queries) | |||
| Search within a part of a column | Excel Discussion (Misc queries) | |||
| Search one column and return value from next column | Excel Discussion (Misc queries) | |||
Linear Mode
