Or even just a =hyperlink() formula in an adjacent cell:

=IF(A1="","",
HYPERLINK("#"&CELL("address",INDIRECT("'" & A1 &"'!x99")),"Click me"))

Will take you to x99 of the worksheet that's in A1.

Bill wrote:

Can I do it with a button if I get my selection from the data validation
list, if so how
--
Bill

"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