Web Query From Multiple Cell References

  • In my first worksheet I have a list of states and state abrivations I want to refreence each of the states and return their results on a new worksheet. I've been able to scrap together most of the code, but i'm missing the first part of the code which declares the reference...I Think?!

    Looking forward to you input, thanks!

  • The worksheet attached works great thanks junho!

    But what would I have to change if I wanted to put all the results on the same worksheet, stacked on top of eachother. would I just need to remove the worksheets.add? I tried this but can't get it to work properly.

  • For instance:



    Excel MVP 2011-2014

    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: Web Query From Multiple Cell References

    Hi jpmurph,
    See if this works.

    Regards, Junho