On Sun, 24 Sep 2006 18:03:01 -0700, Moh wrote:
gord dibben i'm still waiting for your reply...
sorry ron rosenfeld but i don't know much about excel but i can understand.
is it possible someone can do me a quick template.
for example it needs to have a dropdown list with names in there and once
the user selects a name a telephone number will appear in a cell.
which i can then edit
thank you
--
please can you help... its urgent
Use Data Validation to set up a list; and then use VLOOKUP to get the phone
number.
The link that gord supplied,
http://www.contextures.com/tiptech.html has
information under Data Validation for enabling the lists, and also information
on using VLOOKUP to get at the data.
However, if you want to possibly edit the phone number back on the original
source, by making changes where it comes up next to your cell with the dropdown
list, you will need to either write a VBA routine, or possibly you can use a
database program.
--ron