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?

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

On Thu, 17 Jul 2008 09:11:04 -0700, stephen
wrote:

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?