Completed

Very simple scraping Excel VBA macro needed -- 3

Hi,

We need someone to write very simple macro downloading data from [login to view URL]

We have an Excel sheet with different tabs in it. In every tab you can find nowgoal "league" page in cell G1. Example "league" pages:

[login to view URL]

[login to view URL]

Macro should scrape list of games in a following format

First column: home team

Second column: away team

Third column: nowgoal ID (Which can be found on the league page after howering on small icon with letter R inside (for example - [login to view URL], nowgoal ID is 1651575)

Outcome of the scraping should be pasted to Excel in first empty rows below row number 30

In cell H1 there will be a number which will tell macro for which match week data should be scraped. In cell I1 there will be a variable (0/1). If I1 = 0, then macro should only download list of games with nowgoal ID for match week specified in cell G1. If I1 = 1 then macro should download list of games with nowgoal ID for all match weeks, starting from match week specified in cell G1

Budget for this job is 20-30 USD as it should take around 1-2 hours to complete

Skills: Excel, Visual Basic, Visual Basic for Apps, Web Scraping

See more: vba code to import data from website to excel, vba web scraping kit, excel vba scrape table from website, excel screen scraping vba, vba web scraping login, extract data from website to excel vba, scraping web page data automatically with excel vba, vba web scraping tutorial pdf, excel vba macro paste adjacent column, paste excel vba macro, excel vba macro databases, excel vba macro programming bids, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, excel vba macro optimization, excel vba macro protect cell, excel vba macro charts, web scraping excel vba, running excel vba macro sql server

About the Employer:
( 17 reviews ) Krakow, Poland

Project ID: #19789112

Awarded to:

pranjalk2902

Hi, Before I give my introduction, let me tell you sir that your scraping project can be accomplished only through a specialized scraping technique and not the ordinary VBA scraping technique. I have tested and downlo More

$20 USD in 1 day
(5 Reviews)
2.4

13 freelancers are bidding on average $31 for this job

mail2vimalarora

Hi, Being experienced in working on several excel vba projects of various complexities, I can help you in getting scrapping work done quickly and efficiently. Waiting for your response for further discussion on it to More

$25 USD in 1 day
(109 Reviews)
5.9
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$30 USD in 1 day
(97 Reviews)
5.7
xinglong717

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin More

$55 USD in 7 days
(12 Reviews)
4.2
shivansh121

Hi Employer, I can extract any data from any [login to view URL] I have scraped the data from these websites & stored scraped data into CSVs and excels as per my clients requirement. :- You can check these websites... More

$53 USD in 2 days
(7 Reviews)
3.6
wangbeizou

Hello. How are you today. I have read and understood this task. I have a lots of experience and very good knowledge of Data structures, Algorithms Design, Computer Architecture. And I'm expert in VBA, Macro etc. More

$40 USD in 1 day
(4 Reviews)
2.7
sergeyprince

Hello. I have got 8 years of rich experiences in VBA. I can do VBA programming as fast as you want .I am Data Processing , Excel VBA Expert who knows the value of time, very hard working and always delivers the work o More

$30 USD in 1 day
(5 Reviews)
2.0
kosal1015

Hi, sir! How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If need, I first can do demo and send it asap. And then you can see it and decide this projec More

$30 USD in 1 day
(1 Review)
1.4
Noyon1122

Hello, I am specialized in Excel, Visual Basic, Visual Basic for Apps, Web Scraping . I am read your project details .please send message me so we can discuss more.. Best Regards

$25 USD in 1 day
(0 Reviews)
0.0
mhussien32

I'm working as a workforce Analyst who is sending a daily macro automated reports, which involves scraping and auto formatting, auto sending emails. and much more. So doing a simple scraper would be very easy for me.

$20 USD in 1 day
(0 Reviews)
0.0
jumarjuaton

Hello I am a Senior Python developer has over 6 years experience in python script/app development. I've built a lot of python scrapers using Scrapy framework and Selenium/Phantomjs/Requests/lxml/bs4 packages. And More

$30 USD in 1 day
(0 Reviews)
0.0
pyrrhusagbon

Hello, I am very interested in your offer. I can guarantee you a meticulous and diligent work being a very professional person and having a great professional conscience. I have a very good typing speed, a good knowled More

$10 USD in 1 day
(0 Reviews)
0.0
swa59a2950f56938

Hello, If you can give me more details of what data you need, ie, what fields and how many etc, i can turn this round quickly for you, i use various scraping bots/miners that will extract the data you need my details More

$30 USD in 7 days
(0 Reviews)
0.0