this will probably be completely obvious to some of you but being a bi
thick its got me stumped. i have a workbook which contains the result
and a table for the current premier football league.i have two range
in the worksheet (myresults and mytable). What needs to happen is th
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 b
able to run successfully for any number of teams in the league and an
number of matches played. both of these should be detected from th
data. you may assume that the spelling of teams names in the result
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 th
myresults range, eg.tottenham, and get it to correspond with wher
tottenham may happen to be in the mytable range?

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

chri

+-------------------------------------------------------------------
|Filename: Table.zip
|Download: http://www.excelforum.com/attachment.php?postid=3989
+-------------------------------------------------------------------

--
cjsmith2
-----------------------------------------------------------------------
cjsmith22's Profile: http://www.excelforum.com/member.php...fo&userid=2852
View this thread: http://www.excelforum.com/showthread.php?threadid=48182