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!
Bookmarks