You can reference another sheet!

Just add a name to that sheet range, InsertNameDefine..., and use the name
rather than the range directly.

--
__________________________________
HTH

Bob

"Nat Govender" <Nat wrote in message
...
Hi All,

I know that in Excel it says that you cannot reference a diffetent
worksheet
when it comes to data validation, however is there any macro that I could
use
or is there a formular or is there any other way ?



Your help would be greatly appreaciated.



Thanks in advance
Nat Govender