There is a website which has a nice table with values in it generated daily and I want to be able to copy that entire table into a spreadsheet so that I can use macros and manipulate that data to another spreadsheet. How can I copy that data from the website lets say everytime the workbook is opened
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How to copy from a website to spreadsheet
- Thread starter FilipT
- Start date
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Have you tried ... under the Data tab > Get External Data > From Web?
It's fairly straightforward in how it guides you along. There are even yellow arrow in areas where there is a ready-to-go table. But there can be challenges if you need to either log into a site or the info isn't in a table.
It's fairly straightforward in how it guides you along. There are even yellow arrow in areas where there is a ready-to-go table. But there can be challenges if you need to either log into a site or the info isn't in a table.
Upvote
0
Similar threads
- Solved
- Replies
- 3
- Views
- 376
- Question
- Replies
- 3
- Views
- 414
- Solved
- Replies
- 10
- Views
- 704
- Question
- Replies
- 3
- Views
- 117
