team selection by web query

**excellentexcel** · 03-02-2009, 09:43 AM

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

**excellentexcel** · 03-02-2009, 10:46 AM

is there any way i can get the web address to be automated by the cell selection ?

**excellentexcel** · 03-02-2009, 12:24 PM

bump bump bump
i have attached how it could look

**excellentexcel** · 03-02-2009, 02:36 PM

this is how id realy like it to look
i really would appreciate any help

maybe a lookup function to see whats in e1
then return the number in e5( for example)

and then a look up to see g1 and return in g5?

**excellentexcel** · 03-02-2009, 06:14 PM

aha
a lot of playing around has got me to here
im wondering if i can now do a macro to web query

**excellentexcel** · 03-02-2009, 06:39 PM

hi guys
im sorry if im confusing anyone
im having trouble with the last bit of getting the address to change
i have destination cells done and updating cell
but if anyone could work out the key that im missing i would be seriously grateful