Thread
:
Dropdown menu
View Single Post
#
4
Fred
Posts: n/a
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
Reply With Quote