Excel Web Scraping Macro
Budget: $30 – $250 AUD
I require a macro/script to automatically download a series of CSV files and import them into sheets of an existing Excel file.
The sequence of events is broadly as follows;
- On one sheet there will be 8 cells that I will populate manually. Each cell represents the name of a greyhound for which I would like to source and download a csv file for.
- Unfortunately, I dont think the name of the greyhound is contained within the URL. So the macro would have to navigate to a search bar within the website, search for the name that I have populated within the cell, navigate to the first result, then navigate to the CSV download link.
- Then I need the macro to delete any existing data in the 8 individual sheets, and then copy all data from the downloaded CSV into the 8 individual sheets
The sequence of events is broadly as follows;
- On one sheet there will be 8 cells that I will populate manually. Each cell represents the name of a greyhound for which I would like to source and download a csv file for.
- Unfortunately, I dont think the name of the greyhound is contained within the URL. So the macro would have to navigate to a search bar within the website, search for the name that I have populated within the cell, navigate to the first result, then navigate to the CSV download link.
- Then I need the macro to delete any existing data in the 8 individual sheets, and then copy all data from the downloaded CSV into the 8 individual sheets