hi guys
i have an idea that i will be able to select a team in sheet1 cell a1 via a dropdownlist and also c1 giving a home and away team
all teams have there own unique number which i would be able to list them all
it would then look at c1 compare it against the list and use that number
then on sheet two
it would return the results
web address is http://www.soccerbase.com/head2.sd?t...42&team2id=154
arsenals number is 142
aston villa are 154
is there any way i could go about this easily?
im sure it can be done just need pushing the right way
thanks gents
Bookmarks