I'm trying to do a data validation list, and in excel I can't specify the source from another Worksheet. Is there a way to do it in Excel, or if no in VBA?
I'm trying to do a data validation list, and in excel I can't specify the source from another Worksheet. Is there a way to do it in Excel, or if no in VBA?
If you use a range you can access it for data validation from any sheet
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
??
I don't understand.
When I specify in the source: =Sheet2!$A$1:Sheet2!$A$7, I get the error message: "You may not use references to other worksheets or workbooks for Data Validation criteria"
If you use a range NAME you can access it for data validation from any sheetOriginally Posted by lucas
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
You can also use indirect to use a list from a different sheet. Try using this for your data validation:
=INDIRECT("Sheet2!A1:A10")
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln