Unless you get that range a workbook level name:
http://www.contextures.com/xlDataVal01.html#Name
(from Debra Dalgleish's site)



Marcelo wrote:

Hi Bill,

you can't, a list for data validation porpose must be on the same sheet

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

"Bill" escreveu:

I have a validation list on sheet 1 and I need the selection from that list
to take me to sheet 2 or sheet 3
--
Bill

--

Dave Peterson