|
|
#1
03-08-2016, 03:57 AM
|
|||
|
|||
Data Validation - List
Hi,
I have a drop down list on one sheet which looks at a list of peoples names on another worksheet, when I add a line in this sheet to add another name the list then searches on the worksheet it is on. For example Worksheet 1 Worksheet 2 Dropdown list List of names (A1:A50) Once I add a name to the list it searches A1:A50 on worksheet 1 Any ideas what is happening on this ? Thanks 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Trying to get Data into Validation List according to Client Name and Document Type
|
Maoz | Excel | 5 | 01-24-2016 01:17 AM |
|
Data Validation List based on Two Named Ranges
|
Rich18144 | Excel | 4 | 01-14-2016 04:37 AM |
|
Data validation list filter with range defined by OFFSET
|
Mango123 | Excel | 4 | 03-18-2014 02:52 PM |
| How to "hard link" two adjacent cells to a data validation drop down list? | Geza59 | Excel | 10 | 10-19-2012 11:56 AM |
|
Conditional data validation (list drop-down)
|
click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
Windows 8 
Office 2007
Threaded Mode