team selection by web query

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

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

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

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

im trying things along the lines of

Please Login or Register  to view this content.

and getting syntax error

wondered if any of you more clever people than me could utilise this page?

http://www.business-spreadsheets.com/forum.asp?t=40

bump bump bump
surely ive not stumped the forum

aaaaargh
well and truly stumped
even if someone could say this wasnt possible would be better but im sure it must be

some code i found on net if anyone clevered than me can help

Please Login or Register  to view this content.

Please see attached workbook.

It uses 3 querytables on sheets "head to head", "home team" and "away team" and refreshes each from 2 team id parameters on "input sheet".

t-j
thank you so so much
thats exactly what ive been after
jeez i was doing my brain in
absolutely first class
and im sure a lot of people will learn a lot fro this
thank you so much

hi t j
if you are reading this would you please be ind enough to take a look here for me?
http://www.excelforum.com/excel-prog...web-query.html
thanks for your help