Using the Tutorial he
http://www.contextures.com/xlDataVal02.html
I created a dependent list via data validation. My data for both the
main list and the dependent list are on the same sheet, though the
lists are being used on another sheet in the same workbook. My trouble
is creating the dependent data validation using the INDIRECT function.
I am using: =INDIRECT(Data!A2) for which I receive the following
error: "You may not use references to other worksheets or workbooks for
Data Validation criteria." This is where I am currently stuck. I
*really* do not want to have the data for the list on the same sheet
that I am working on. Any help? Is there another way to create a
dependent list and have it work across worksheets in the same workbook?

Thanks,
~Dan