Power Query - In-Running Ratings

Post Reply
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Power Query - In-Running Ratings

As per a post by Dallas viewtopic.php?f=61&t=13533

This query scrapes the data and puts it into a Table in Excel.

In-Running Ratings.xlsx

Screenshot 2021-06-24 112703.png

To update, simply select a cell in the Table and go to Data Tab > Refresh

The query will update only with 'Todays' date and insert that date accordingly. To keep a record of each days records I added a 2nd sheet that allows you to copy 'n paste from TodaysDate tab to the HistoryData tab.

To quickly do this select any cell inside the TodaysDate table and press CRTL A, then CRTL C. Go to the HistoryData tab and select the last cell in the range (in the Date column), then move down one more cell (so it seems you are outside the table) and then press CRTL V.

You will know if it has copied properly as every other row is shaded. If it doesn't, it means you have not copied it properly.

Design and style is completely up to you :)
You do not have the required permissions to view the files attached to this post.
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

I have not tested this each day, so I will continue to keep a eye on it.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

Goodstuff.....

PS

The server is up mate for the 12 instead of nine.

Collect your green bro.
User avatar
waywyrd
Posts: 80
Joined: Tue May 23, 2017 4:18 pm

Thanks for sharing this.
Post Reply

Return to “Excel Power Query”