Thread: Auto Fill
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jay
 
Posts: n/a
Default 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?