Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filter
I have a list of customer names address and phone numbers I would like to
type a letter or first couple of letters in a cell and all customer names beginning with that letter appear then be able to chose one of them. Once I have choosen a customer then the address and phone number will apper. |
#2
|
|||
|
|||
filter
Mike
You could use a Data Validation List in a cell drop-down for the customer names and VLOOKUP to return the address and phone number. See Debra Dalgleish's site for for info and methods. http://www.contextures.on.ca/xlDataVal01.html for DV http://www.contextures.on.ca/xlFunctions02.html for VLOOKUP However, DV drop-downs are not capable of providing autocomplete. For workaround using a combo-box see. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben Excel MVP On Mon, 24 Oct 2005 08:55:04 -0700, "mike4605" wrote: I have a list of customer names address and phone numbers I would like to type a letter or first couple of letters in a cell and all customer names beginning with that letter appear then be able to chose one of them. Once I have choosen a customer then the address and phone number will apper. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |