Hi Phil,

I think you should be able to do this without the need for Macros using
worksheet functions like Sumif. for example if you use
=SUMIF(Sheet2!A1:A50,Sheet1!A1,Sheet2!B1:B50) this will sum the value
in column B on sheet 2 where the value in column A equals that of sheet
1 cell A1. So if cell A1 (sheet1) equals spain, anytime on sheet2 where
spain appears between the ranges of A1 to A50 the values in B1 to B50
will be added.

If I have misunderstood or not explained well enough then post back.

Cheers,

James


phil2006 wrote:
If I have a list of nations with values assigned to them based on recent
sport results, is there any way I can add the value I wish to assign
from the results that I have on my second page? For example, Spain may
have played 5 games and I want to use macros to add the value of their
results from page 2 on to page 1. I just don't know how to assign the
value each time a team name appears.
Any help would be of great assistance,

Cheers,

Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=548544