Copy Data from Different pages of a website into Excel

[ritinrulz]

I need to copy some Olympics data from the Olympics website about Medal tally. The website is Medal Count - Olympic Results & Medalists | IOC , and i need to look for Medalists (the right hand side) By country and then by Olympics. This opens a new page with the following Columns (which i need in excel) Sport Event Result medal/athlete. The only problem to copy it and paste it takes a very long time and then you also have to shift between pages. Is there a faster way to get all the data for each Olympics for each country (Maybe a Macro/Web Query).
Please i really need to collate this data. Till now i have just managed to finish 1 Olympics only (3 days)

Thanks,

Ritin

 

[ritinrulz]

I don't think there is any other option than copy and paste.You have copy whole data and then paste it into Excel sheet in a sorted format as per you want and then link it to your site.


Thanks,

its just too tedious, but once i have it all in excel, i can do a lot with it. Thanks for looking into it.

Regards,

Ritin