Auto Fill
My excel table (Order) is as follows:
Date Customer Tel # Order #
1/26/06 Cathie Lee 319-345-3744 35297853
1/26/06 Jack Morrison 232-475-3438 75375908
..
Every day I have to enter, in customer column, customer names who makes
order.
I have separate Excel table( Customer Info) with all info on customers as
follows
Customer Tel # Term ..............
Cathie Lee -------------
Question) In a customer columm of an order table, I just want to type couple
of customer alphabet and to make the full name and Tel # should pop up. How
can I relate Customer Info and Order tables together?
|