Hi Stefi

This was just what I thought was an easy example of what I want to do.

Suppose Sheet 1 Column A has


Arsenal
Chelsea
Bolton
Everon
Liverpool
Manchester United

Their league positions are on Sheet2 column B

Chelsea
Manchester United
Arsenal
Bolton
Liverpool
Everton


Now suppose I'm in sheet 1 cell a1 - Arsenal - I want to be able to invoke a
macro to take me to sheet2 and the cell that is occupied by Arsenal which in
this case might be b3 - it might be a different cell next week so I need the
instruction to find the relevant cell in sheet2 that is occupied by arsenal.

Cheers

John

"Stefi" wrote:

Hi,
In the second sheet are teams in different leagues mixed up, say

Celtic 1st (in the Scottish league)
Arsenal 1st (in the English league)
1st (in the Italian league)

If not, is the league the team belongs to marked in the first sheet, e.g.

Arsenal English
Celtic Scottish
Milan Italian

Stefi

€žjohn dawson€� ezt Ã*rta:

Hi I'm new to this community but use excel a lot. I'm stumped by this one
though : suppose I have column in one particular sheet with say all of the
names of the top footlball teams in individual cells in alphabetical order
down the column. I also, say, have another sheet in the same workbook with a
similar column of the same names but in this case it's their position in a
league . I would like a macro so that I can move the cursor on a team in my
first column, then cnrtl"x" and I move to the same team on my next sheet.

I can't work this one out to save my live so please help