|
|
|
|
#1
03-08-2016, 06:24 AM
|
|||
|
|||
Hi,
Have tried but no luck. I have 20 dropdown lists all connected to this other workbook and when I insert a new line the dropdown list I am doing it for is OK but all of the other drop down lists start to pick up the location of the worksheet it is on. Any other suggestion I can try? 
|
|
|
|
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
Hybrid Mode