+ Reply to Thread
Results 1 to 3 of 3

Refreshing Web Query

Hybrid View

  1. #1
    Registered User
    Join Date
    03-21-2012
    Location
    Sunderland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Refreshing Web Query

    Greetings,

    I am creating a sheet which updates from a web query, which I can extract further details onto separate sheets. Upon setting up the web query, I altered the formatting to how and I wanted it and deleted any extraneous columns. However, when I do a refresh the formatting is lost, despite me ticking this option. Any help would be most appreciated.

    Daily Odds Checker.xlsx

  2. #2
    Registered User
    Join Date
    03-21-2012
    Location
    Sunderland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Refreshing Web Query

    Further to my earlier request, I've had a play around and created a macro that seems to the trick. The Button on sheet one, will populate sheet two with the necessary info. My problem now is the hyperlinks in the odds column are not working. Can this be rectified please ?
    Odds Checker v2.xlsm

  3. #3
    Registered User
    Join Date
    03-21-2012
    Location
    Sunderland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Refreshing Web Query

    Ok, so I've made some progress on my own, but now have hit a brick wall. The "Matches" sheet updates and filters as I want, however I want those filtered rows to be copied to the "Results" sheet. I have no idea how to code this. My intial attempt at recording a macro worked, until I realised that the row numbers wouldn't always be the same !

    Odds Checker v3.xlsm

    Any help would be most appreciated.

+ 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