MrExcel Publishing
Your One Stop for Excel Tips & Solutions

data validation problem

Posted by Brent Cahill on April 07, 2001 8:31 PM

Is it possible to have a cell use data validation with data that is in another sheet, or does the data for the combo box have to be on the same sheet.

Posted by steve on April 07, 2001 9:27 PM

how about pasteing a reference of the data you want to the sheet with the data validation

Posted by Dave Hawley on April 07, 2001 10:15 PM

Hi Brent

Yes it is. You can use either of these 2 methods:



Where "MyRange" is a named range on sheet2

I also have some more on Validation on my WebSite under "Handy Hints"


OzGrid Business Applications