Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Moving thru sheets in Excel
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 |
#2
|
|||
|
|||
Moving thru sheets in Excel
Do you mean that in the second sheet the ORDER of team names is their
position No? 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 |
#3
|
|||
|
|||
Moving thru sheets in Excel
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 |
#4
|
|||
|
|||
Moving thru sheets in Excel
Hi Stef,
Yes, the important thing here is that the ORDER of the teams is different on the second sheet to on the first. After locating a particular team with the cursor on the first sheet, what is the macro which will move the cursor to the same team on the second sheet. Your help would be much appreciated. "Stefi" wrote: Do you mean that in the second sheet the ORDER of team names is their position No? 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 |
#5
|
|||
|
|||
Moving thru sheets in Excel
Hi John,
This is the macro! Sub Teamfind() Dim keresrng As Range csapat = ActiveCell.Value Sheets("Position").Select <== Change Position to the actual name of 2.sheet! Set keresrng = Range("A2:A65536") Rows(WorksheetFunction.Match(csapat, keresrng, 0) + 1).Select End Sub Do you know how to assign hotkey ctrl+x? Regards, Stefi €žjohn dawson€ť ezt Ă*rta: Hi Stef, Yes, the important thing here is that the ORDER of the teams is different on the second sheet to on the first. After locating a particular team with the cursor on the first sheet, what is the macro which will move the cursor to the same team on the second sheet. Your help would be much appreciated. "Stefi" wrote: Do you mean that in the second sheet the ORDER of team names is their position No? 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 |
#6
|
|||
|
|||
Moving thru sheets in Excel
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 |
#7
|
|||
|
|||
Moving thru sheets in Excel
Stefi
Sorry please disregard last post some confusion!!! Many thanks for the macro - will let you know how i get on cheers "john dawson" wrote: 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 |
#8
|
|||
|
|||
Moving thru sheets in Excel
Stefi
Many,many thanks - worked a treat, cheers "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 |
#9
|
|||
|
|||
Moving thru sheets in Excel
You are welcome! Thanks for the feedback!
Stefi €žjohn dawson€ť ezt Ă*rta: Stefi Many,many thanks - worked a treat, cheers "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating, Deleting and inserting rows over two Excel Sheets | Excel Worksheet Functions | |||
how can i open multiple excel sheets separately | Excel Discussion (Misc queries) | |||
control-tab should move between Excel sheets without a mouse. | Excel Worksheet Functions | |||
automate creation of sheets in excel | Excel Worksheet Functions | |||
How do I print all sheets of an Excel workbook from explorer? | Excel Discussion (Misc queries) |