You can use a HYPERLINK formula to do this - give me the exact cell
references and sheet names that you use and I'll knock up a formula for you
to try.

Hope this helps.

Pete

"Bryan De-Lara" wrote in message
...
How can I click on a name in column A (there are 250 names in this column)
on sheet 1 and go to the corresponding name on sheet 2?
On sheet 1 they go down the column, on sheet 2 they go across the row. I
have tried to do a macro with no luck. Is there any other way?
Help would be appreciated.

Bryan.