MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Data Validation

Posted by Aaron on January 02, 2002 12:14 PM

Is there any way to get Data Validation to look at another Sheet in Excel97? Any Help would be appreciated.

Posted by IML on January 02, 2002 12:21 PM

Highlight and name your list via the name box (ie LIST)
when in validation allowing for list, type in

(be sure to use the equal sign)

good luck

Posted by More Beer!!! on January 02, 2002 12:22 PM

YES, you have to "name" the cells in the other sheet by using "insert, name, define". Then use the name you created in your data validation...