<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:Standardowy; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> I am a moreless advanced user of Excel, which has encountered a problem. I have my own "quasi-program" for betting, which I created in Excel. Over time, I had more and more tables and statistics that were manually copied from the Internet. Now I have decided to use the automatic updating of data from the tables by a query from the web. Unfortunately, the webpage from which the data is downloaded makes it a little bit complicated.
For example :
http://www.soccerway.com/...regular-season/
I wanted it to download automatically both the Table called "League table" and the "Wide table". This was to be split into two separate queries. Unfortunately, every time I set a query in Excel it updates only the "League Table". Let me emphasize that I am not an expert in web programming, but it probably has something to do with the fact that both of the tables have the same Internet address. Is there any possibility to work it around ?I would be very grateful for any help. Usually I find the solutions to the problems I encounter in Excel by myself but this time I must consult with experts.
Best regards
For example :
http://www.soccerway.com/...regular-season/
I wanted it to download automatically both the Table called "League table" and the "Wide table". This was to be split into two separate queries. Unfortunately, every time I set a query in Excel it updates only the "League Table". Let me emphasize that I am not an expert in web programming, but it probably has something to do with the fact that both of the tables have the same Internet address. Is there any possibility to work it around ?I would be very grateful for any help. Usually I find the solutions to the problems I encounter in Excel by myself but this time I must consult with experts.
Best regards