Posted to microsoft.public.excel.misc

Stephen

external usenet poster

Posts: 106

autofill or auto reference

I have a list on sheet 1 a1-a100 with names of clients in it. Same sheet,
column B1-B100 i have the phone number.

If in sheet 2, i put the name of the client in one cell, is there a way i
can get the phone number to auto fill in on the next cell in the same sheet?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
AutoFill with sheet reference help	TimeCloud	Excel Worksheet Functions	3	May 17th 08 05:26 PM
AutoFill with sheet reference help	TimeCloud	Excel Worksheet Functions	0	May 17th 08 01:10 AM
Autofill a Sheet Reference	JOJO193	Excel Worksheet Functions	7	April 18th 08 01:00 AM
reference autofill.	mtnone	Excel Worksheet Functions	4	May 30th 06 08:46 PM
Autofill/Reference Confusion	Patrick White	Excel Worksheet Functions	0	June 4th 05 01:07 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us