How

[Bryan De-Lara]

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.

 

[Satti Charvak]

Try using =row() and =column() functions.

 

[Pete_UK]

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.delara]

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







- 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.

 

[Pete_UK]

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

 

[bryan.delara]

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





- Show quoted text -

Yes I can now confirm Pete, I've added a column so that B is empty.

Bryan

 

[Pete_UK]

Okay, Bryan, put this formula in B6:

=HYPERLINK("#A!R6C"&MATCH(A6,A!$D$6:$IS$6,0)+3,"jump")

and then copy down to B255. Note that the formula is using R1C1
notation, but you don't need to do anything about this.

You will see the word "jump" next to each name, so just click on one
of these to take you to the cell that contains that name along row 6
of the sheet named A. The names do not have to be in the same order on
both sheets.

Hope this helps.

Pete

 

[bryan.delara]

Okay,Bryan, put this formula in B6:

=HYPERLINK("#A!R6C"&MATCH(A6,A!$D$6:$IS$6,0)+3,"jump")

and then copy down to B255. Note that the formula is using R1C1
notation, but you don't need to do anything about this.

You will see the word "jump" next to each name, so just click on one
of these to take you to the cell that contains that name along row 6
of the sheet named A. The names do not have to be in the same order on
both sheets.

Hope this helps.

Pete






- Show quoted text -

Pete, I've tried it, it works great, thanks a million.

Bryan

 

[Pete_UK]

You're welcome, Bryan - thanks for feeding back.

Pete