You can put the table onto another sheet, but instead of using cell
references, you use named ranges. Data Validation works with cell
references, as long as they are in the same sheet, but stangly Data
Validation will work if you use named ranges, which refer to cells in
another sheet.


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=536648