Enter a customer name in the invoice workbook when the names are .
 

We use Excel to make invoices for our customers. I have a customer list of
800 in one workbook. The invoices are in another workbook. At this time, we
manually type in the customer name & address etc. How can I set up either a
combo box or a formula that when I type in the first couple of letters of a
customer name that Excel will enter the remaining info automatically. I do
not want the customer list in the same workbook. Thanks for your help