How to set-up data validation between sheets?
 

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.

How to set-up data validation between sheets?
 

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

"RobS" wrote:

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.