I intend to give you a formula that goes in column B of your names
sheet, next to the name, so that you can click on that cell to jump.
Can you confirm that you have nothing in cells B6 to B255?

Pete

On Nov 5, 3:51*pm, wrote:
On 5 Nov, 11:44, "Pete_UK" wrote:





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

"BryanDe-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.- Hide quoted text -

- Show quoted text -

Thanks.
I have Sheet2 (Home) with names starting at A6 down to A255.
Sheet3 (A) with names starting at D6 across to IS6
It would be great if you could do that. Thanks in advance Pete.- Hide quoted text -

- Show quoted text -