autofill

[stephen]

I have setup a worksheet in excel to do quoting in. What i want to be able to
do is start typing the clients name in the customer spot, and it autofill
with the rest of it. But i still need to have the option to add different
customer's names to the quoting sheet. Is this anyway possible?

 

[Gord Dibben]

See Debra Dalgleish's site for adding a combobox with autocomplete to a Data
Validation dropwdown list.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP