How to set-up data validation between sheets?

[Guest]

I'm losing data validation when I carve up an existing spreadsheet.
Validation values are hidden on sheet #1 currently in rows 2-35.
If I carve up the spreadsheet (for example: I save rows 50-250 onto another
workbook), I lose the validation on the new workbook.
Can I set up the values on the original workbook on Sheet #2 and somehow
validate back to sheet #1? How?
Thanks.

 

[Guest]

If you name the data validation source range, you can access it by that name
from other worksheets. Select your range in rows 2-35 and go to Insert >>
Name >> Define and call it something. Then in your validation select "List"
and in the Source field type "=Name" where Name is the actual name you
assigned above.

HTH