Try using =row() and =column() functions.
--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"Bryan De-Lara" wrote:

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.