+ Reply to Thread
Results 1 to 2 of 2

Using WebTable to retrieve correct data

  1. #1
    Registered User
    Join Date
    07-29-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    2

    Using WebTable to retrieve correct data

    I've written (and copied with some searching around the net) a worksheet that uses user input from Sheet1 to load a table from a web page on Sheet2 and then a formula on Sheet3 processes that webpage data. The problem I'm having is this....

    Due to an advertisement on the webpage, sometimes the WebTable I need is 2, other times it's 3. I've tried one workaround which is to specify with a drop down menu which table to load, so if the data loads 2 and it's incorrect, then I can load 3 for the proper data. The problem with this is, the incorrect data is smaller column-wise (by 4 rows) so when I reload the correct data, it messes up my formula. I've tried to make the formula absolute, but to no avail.

    So...first, it seems the real solution would be to have excel know when there is an ad that messes with the WebTable order on the page. Besides that however, I'm ok with changing it and reloading except for the formula being messed up then. Any tips/pointers to what I can do to fix this?

    Thanks!

  2. #2
    Registered User
    Join Date
    07-29-2009
    Location
    Colorado
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Using WebTable to retrieve correct data

    Any ideas, any other info that I need to provide that would be helpful?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1