Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro for Auto Fill carolini Excel Discussion (Misc queries) 2 December 6th 05 09:11 PM
stop auto fill from thinking for itself!!!!!!! 1vagrowr New Users to Excel 3 November 5th 05 03:27 PM
Auto Fill Options adarling Excel Discussion (Misc queries) 1 April 8th 05 03:09 AM
Auto fill option box disappeared sbrimley Excel Worksheet Functions 5 February 4th 05 03:21 AM
Auto Fill Options Patti B Excel Discussion (Misc queries) 3 December 9th 04 12:49 AM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"