Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create dropdown menu using Combo box | Excel Worksheet Functions | |||
create dropdown menu | Excel Worksheet Functions | |||
Dropdown menu | Excel Worksheet Functions | |||
My file menu is not on the menu bar. | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |