Pull real-time data off the internet using macro

[liamsmith]

Hello,

I am currently trying to set up an excel workbook that keeps track of up to date golf leaderboard statistics. I would like to have a macro that pulls in data from the following link: PGA Championship Leaderboard and results in an up to date table in my excel file that includes the following columns: "POS", "PLAYER NAME", "THRU", "ROUND", "R1", "R2", "R3", "R4". If anyone could post the VBA code for this macro that I could Copy and Paste in that would be an unbelievably big help! If not some fairly detailed help on how to write this would also be much appreciated as I have no experience with VBA, coding or macros but have to do this for my job

Thanks

 

[jamescooper]

Hello,

I am currently trying to set up an excel workbook that keeps track of up to date golf leaderboard statistics. I would like to have a macro that pulls in data from the following link: PGA Championship Leaderboard and results in an up to date table in my excel file that includes the following columns: "POS", "PLAYER NAME", "THRU", "ROUND", "R1", "R2", "R3", "R4". If anyone could post the VBA code for this macro that I could Copy and Paste in that would be an unbelievably big help! If not some fairly detailed help on how to write this would also be much appreciated as I have no experience with VBA, coding or macros but have to do this for my job

Thanks

Hello Liam,

Great tournament and well done to Jason Day, at last!

I did this recently.

In excel if you go to Data > From Web > Import, paste website in there it should import the data into excel for you.

Then should be a case of formatting it to get the actual data on the website you want, which I imagine is the players names/scores from your description.