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.
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
Power Query - In-Running Ratings
- paspuggie48
- Posts: 688
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 688
- 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.
- Realrocknrolla
- Posts: 1904
- 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.
PS
The server is up mate for the 12 instead of nine.
Collect your green bro.