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