Help with updating tables

jamtay317

Well-known Member
Joined
Mar 6, 2013
Messages
769
I have 2 tables that I want to update every week after the web sight has been updated, how can I update them Automaticly?

table name: Standings8Ball

RANKTEAM #TEAM NAMEWEEKS SCOREDPOINTS WON LAST WEEKTOTAL POINTS
784707WTP dp3 134124
384703Sofa Cues dp5 1311110
284702The Shooting Gallery 137109
984709Slow Roll It 1311109
884708Fore 5 6 L5 135104
184701Cheap and Easy L8,12 dp12 131099
1084710Chalkie Balls 13899
584705Breaking Bad dp4 131096
684706Point Of Impact dp9 13794
1184711Smooth Strokers L3 13693
1284712Meow Woof 13993
484704Sharpshooters dp12 13685
1384713It's Just a Game 13683
1484714The Woolfpack II 13881

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>


table name: Standings9ball
294702The Shooting Gallery 1370973
794707WTP dp3 1378960
894708Fore 5 6 1370942
494704Sharpshooters dp8 1397932
994709Slow Roll It 1362924
594705Breaking Bad dp4 1382912
1394713It's Just a Game 1354905
1294712Meow Woof 1343903
394703Sofa Cues 1386883
1094710Chalkie Balls 1376876
694706Point Of Impact 1364858
1194711Smooth Strokers 1358845
194701Cheap and Easy dp12 1370804
1494714Bye 130

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

the websight requires a username and password

please help!
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

jamtay317

Well-known Member
Joined
Mar 6, 2013
Messages
769
I try to copy paste the table from the web, but it puts it all the data in the same cell
 

Watch MrExcel Video

Forum statistics

Threads
1,122,668
Messages
5,597,463
Members
414,145
Latest member
lonnie451

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top