Hello!
I would like to ask a favor from the specialists here : I need a VBA code that can copy some tables/ charts from a website. The website is bet365.com, and the tablesare placed in the section: Results (at the bottom of the page)> Search Criteria: (Sport: Virtual Soccer, Date: Last 48 hrs, Search by : Virtual Soccer). Then you click the button “Get Results”. Then the website will display a list of the matches from the last 48 hrs. First of all, I need the code to open each match in a separate window and to copy a table from that page, and then to paste it in Excel. Secondly, if I repeat the action after 8hrs, for example, the site will show the matches from thelast 48hrs, and the code will have to check which is the last table I copied and to continue to paste from that point on, on the same sheet.In order to make things more clear, I also attached a file illustrating on Sheet2 how Ineed things to look in the end.
Thank you in advance!
PS: In order to be able to access the section “Results”, autentification is required, and I will provide the usename and password in private.