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

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

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

Hi Brent

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

=INDIRECT("Sheet2!$C$1")

....Or

=MyRange
Where "MyRange" is a named range on sheet2


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


Dave

OzGrid Business Applications