stathis95194
New Member
- Joined
- Jun 27, 2015
- Messages
- 2
Hello everyone. I need help trying to scrape data from a website and paste them in excel.
My VBA knowledge is very limited so if anyone can help i would appreciate it.
So for example i need to put on A1 the id of the league and run a macro which will scrape data (football matches) from the following URL:
1. Bundesliga 2015/2016 :: Schedule :: footballzz.co.uk
1. Bundesliga 2015/2016 :: Schedule :: footballzz.co.uk
1. Bundesliga 2015/2016 :: Schedule :: footballzz.co.uk
etc
This need to be run on a loop as each league has 51 rows on each page for a maximum of 9 pages
So the date of each page should be placed below the last row of the previous page.
Any any any help will be greatly appreciated.
My VBA knowledge is very limited so if anyone can help i would appreciate it.
So for example i need to put on A1 the id of the league and run a macro which will scrape data (football matches) from the following URL:
1. Bundesliga 2015/2016 :: Schedule :: footballzz.co.uk
1. Bundesliga 2015/2016 :: Schedule :: footballzz.co.uk
1. Bundesliga 2015/2016 :: Schedule :: footballzz.co.uk
etc
This need to be run on a loop as each league has 51 rows on each page for a maximum of 9 pages
So the date of each page should be placed below the last row of the previous page.
Any any any help will be greatly appreciated.