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
