Dropdown menu
 

I have technical services in several cities, and several customers in those
cities. I am creatinf a book to manage this services and created an excel
book which has 3 worksheets.
1.Planning Sheet
2.List of customers
3.List of service agents
I make dropdown lists for customer and services columns on planning sheet.
The data is taken from sheet 2 and 3.
While working on planning sheet (1) , if user selects Customer1 (A1) from
drop-down list, can I import automatically his phone number into B1? This
data is already on Worksheet 2 (List of customers) This is something about
making links between cells.
Thanks a lot

See http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hakan" wrote in message
...
I have technical services in several cities, and several customers in
those
cities. I am creatinf a book to manage this services and created an excel
book which has 3 worksheets.
1.Planning Sheet
2.List of customers
3.List of service agents
I make dropdown lists for customer and services columns on planning sheet.
The data is taken from sheet 2 and 3.
While working on planning sheet (1) , if user selects Customer1 (A1) from
drop-down list, can I import automatically his phone number into B1? This
data is already on Worksheet 2 (List of customers) This is something about
making links between cells.
Thanks a lot

You can use a Vlookup formula in cell B1, to return the matching phone
number. There are instructions in Excel's Help, and he

http://www.contextures.com/xlFunctions02.html

Hakan wrote:
I have technical services in several cities, and several customers in those
cities. I am creatinf a book to manage this services and created an excel
book which has 3 worksheets.
1.Planning Sheet
2.List of customers
3.List of service agents
I make dropdown lists for customer and services columns on planning sheet.
The data is taken from sheet 2 and 3.
While working on planning sheet (1) , if user selects Customer1 (A1) from
drop-down list, can I import automatically his phone number into B1? This
data is already on Worksheet 2 (List of customers) This is something about
making links between cells.
Thanks a lot


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Send me an email at and I will forward a file.

Hakan wrote:
I have technical services in several cities, and several customers in
those
cities. I am creatinf a book to manage this services and created an
excel
book which has 3 worksheets.
1.Planning Sheet
2.List of customers
3.List of service agents
I make dropdown lists for customer and services columns on planning
sheet.
The data is taken from sheet 2 and 3.
While working on planning sheet (1) , if user selects Customer1 (A1)
from
drop-down list, can I import automatically his phone number into B1?
This
data is already on Worksheet 2 (List of customers) This is something
about
making links between cells.
Thanks a lot