Automated data scraping from websites into Excel

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
http://www.familycomputerclub.com
You can scrape, pull or get data from websites into Excel by performing a few simple steps.
1. record a macro to find out how one or many tables or data can be scraped from the website
2. Study the code carefully
3. Create an Excel sheet containing the links that get you the data from the appropriate web pages
4. Automate the process using a loop that creates
a) New worksheets
b) Automatically changes the link to the web pages that have the required data
You can view the complete Excel VBA code here:

https://www.exceltrainingvideos.com/scrape-data-automatically-from-websites-into-excel/

Interesting Links:
http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm
Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V
If you are from India you can get this book here: http://amzn.to/2jzJGqU

Видео Automated data scraping from websites into Excel канала Dinesh Kumar Takyar