+ Reply to Thread
Results 1 to 2 of 2

Rugby Standings - I just want the standings table and not the entire page

  1. #1
    Registered User
    Join Date
    02-05-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    33

    Rugby Standings - I just want the standings table and not the entire page

    Good morning,

    I am creating a spreadsheet with an external connection that pulls in the standings for the Premiership Rugby standings at this location.

    http://rd.premiershiprugby.com/match...RWeseHiGViq.97

    I created the external link from the Web in Excel 2010. However, I am getting the entire webpage and not just the table. It pulls in a bunch of data that I don't want. When I select the yellow arrow to select the table I want, it only lets me choose everything.

    See attached to see what is pulling in. How do I get just the standings (A33-Q45) and not the entire webpage?

    - MSP
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: Rugby Standings - I just want the standings table and not the entire page

    I don't think it's possible to affect what it downloads but the table can easily be extracted to another sheet using formula or the extra downloaded material can be deleted with a macro.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with standings sheet
    By gbish in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-26-2014, 11:58 AM
  2. standings help
    By intrepid7 in forum Excel General
    Replies: 1
    Last Post: 04-26-2014, 02:14 PM
  3. Team standings
    By sucosam in forum Excel General
    Replies: 11
    Last Post: 05-15-2013, 04:26 AM
  4. [SOLVED] Standings Change
    By JQ27HHH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2012, 12:54 PM
  5. Excel Standings
    By NOLAKeith in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2011, 12:31 PM
  6. Standings
    By sec97reno in forum Excel General
    Replies: 1
    Last Post: 06-18-2006, 02:15 PM
  7. softball standings
    By randyrestg in forum Excel General
    Replies: 1
    Last Post: 06-21-2005, 07:38 PM

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