Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Names in Drop Down List
Hi
I have 2 worksheets in a file. Sheet 1 has personal details of clients & Sheet 2 has details of training that they have taken up. When completing sheet 2 I have created a drop down validation referring to the surnames on the Sheet 1 and when selected it brings across the firstname into the next column. What is happening is that where there are more than 1 person with the same surname there is only one entry for the surname and that is the first one entered. Is there a way to format the validation that will allow for all the entries to appear? And...is there a way to create a drop down list that takes in 2 cols. eg if I was to havel both the first & surnames appear in the list. I would like to keep the breakdown in the names for when doing mail merg. thanks Debbie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Names in Drop Down List
If the surnames are in column A and first names in column B, create a new
lookup list that uses formulas: =A1&", "&B1 That will leave your original date intact but still list all the names "DebbieV" wrote: Hi I have 2 worksheets in a file. Sheet 1 has personal details of clients & Sheet 2 has details of training that they have taken up. When completing sheet 2 I have created a drop down validation referring to the surnames on the Sheet 1 and when selected it brings across the firstname into the next column. What is happening is that where there are more than 1 person with the same surname there is only one entry for the surname and that is the first one entered. Is there a way to format the validation that will allow for all the entries to appear? And...is there a way to create a drop down list that takes in 2 cols. eg if I was to havel both the first & surnames appear in the list. I would like to keep the breakdown in the names for when doing mail merg. thanks Debbie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select multiple names from drop down list | Excel Worksheet Functions | |||
Trying to add names to drop down list in Excel | Excel Discussion (Misc queries) | |||
Trying to add names to drop down list in Excel | Excel Discussion (Misc queries) | |||
How do I add names to a drop down list? | Excel Discussion (Misc queries) | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) |