Data Validation

		Microsoft Office Forums > Microsoft Excel > Excel
Data Validation - List

03-08-2016, 06:18 AM

gebobs

Windows 7 64bit Data Validation - List

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

That's never happened to me, but try one of these:

* Specify the sheet in the range e.g. =[Worksheet 2]!A1:A50
* Use a named range

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:43 PM.