[cjsmith22]

this will probably be completely obvious to some of you but being a bit thick its got me stumped. i have a workbook which contains the results and a table for the current premier football league.i have two ranges in the worksheet (myresults and mytable). What needs to happen is the table needs to update depending on the results that particular week.

the thing that i cant get my head around is this - "the macro should be able to run successfully for any number of teams in the league and any number of matches played. both of these should be detected from the data. you may assume that the spelling of teams names in the results section corresponds exactly to the spelling used in the league table - bearing in mind that a teams name can appear twice in a set of results"

so how do i get my macro to detect, for example whats in cell b2 of the myresults range, eg.tottenham, and get it to correspond with where tottenham may happen to be in the mytable range?

if that made the slightest bit of sense at all, thanks in advance

chris

[OBP]

This sounds a bit like a training exercise.
See this thread for how to loop through a range looking for data.
http://forums.techguy.org/t413548.html
You will actually need 2 loops, one within the called (called nested loops).
The first loop goes through your myresults and the second loop goes through the league table looking for the name that matches your cell value in myresults.

[cjsmith22]

cheers OGP

[cjsmith22]

sorry! obp