Thread: Auto fill name and address

Each day this form is filled out, printed and placed in a book, showing only that day's services rendered to customers. There are several hundred customers (debtors).

What I want is to begin typing the customer's name and have it auto fill (for instance I type Smy and it auto fills with Smythe Trucking). And then the address for Smythe Trucking will automatically fill into the next column.

I've attached a dummy worksheet .... many thanks in advance for your help

Originally Posted by m3site

Each day this form is filled out, printed and placed in a book, showing only that day's services rendered to customers. There are several hundred customers (debtors).

What I want is to begin typing the customer's name and have it auto fill (for instance I type Smy and it auto fills with Smythe Trucking). And then the address for Smythe Trucking will automatically fill into the next column.

I've attached a dummy worksheet .... many thanks in advance for your help

please take help from this link.

http://www.finance30.com/forum/topic...l-with-address