Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Moving cursor to identical cells across multiple sheets
This post is a follow up query to John Dawson's post of 10/28/2005, in which
he asked how to move the cursor from an individual item (eg one of a list of football teams, arranged in alphabetical order) in a column of Sheet 1, to the same item in a similar column on the next sheet. However, in the second sheet the items are in a different order (eg this might be the league positions of the teams on the first sheet). Stef vey kindly provided the following macro which did the job perfectly: 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 My question now is this... Imagine that ALL the teams are still listed on the first sheet. However I need to move the cursor to the identical team which is listed on any one of the following THREE sheets. Following the above example, these could be three different football leagues. It is not known which of the three sheets it is listed on, but it is only listed once on one of the three sheets. Can anybody help, please? Yours, Sue Sch |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Multiple sheets | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Find values from cells in multiple sheets | Excel Worksheet Functions | |||
count cells over multiple sheets | Excel Worksheet Functions | |||
sum difference cells on multiple sheets | Excel Worksheet Functions |