Closed

Very simple scraping Excel VBA macro needed

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: Data Entry, Excel, Visual Basic, Visual Basic for Apps, Web Scraping

See more: vba web scraping kit, excel vba scrape table from website, excel vba pull data from a website, excel screen scraping vba, vba web scraping login, vba web scraping tutorial pdf, vba code examples for excel web scraping, vba code to import data from website to excel, 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: #19776358

16 freelancers are bidding on average $7/hour for this job

Stephenrajs

Hi there, I have scraped amazon, aliexpress, yellow pages ,yelp ,zomato etc. I have 500GB internet with 20mbps speed, i have 6 systems I can do it. I have done many related projects like this. If you are provi More

$5 USD / hour
(100 Reviews)
5.2
bluesea1990

Hello. Welcome! I'm excited that you’re here! *****Excel VBA Expert****** 1. I am an expert in Excel(VBA), Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects i More

$5 USD / hour
(15 Reviews)
4.7
kkc1985612

Hi, I looked at your description carefully and I am very interested in providing my skills in hopes of working with you. I have ample experience in web scraping. -scrap any website using selenium, beautifulSoup, reques More

$8 USD / hour
(14 Reviews)
4.5
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

$8 USD / hour
(12 Reviews)
4.2
vw8277229vw

Hi there, It was really interesting job for me. I carefully gone through your requirements and found you’re seeking for a web researcher. I can perform accurately in this job. Things can be done with me- 1. Collect e More

$3 USD / hour
(4 Reviews)
3.9
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

$5 USD / hour
(7 Reviews)
3.6
isupportu

Hi There, I have done the demo work as you stated , please download the file from below URL and you can open the excel and enable the Macro and simply press "CTRL + g" to execute the macro. [login to view URL] More

$25 USD / hour
(14 Reviews)
3.8
Zadehh

Hello. I am professional Research Writer, Data Entry, MS Office and List Building Expert - Ulvi. I have 5 years of experience in all these professions. I have successfully created, building and editing hundreds o More

$2 USD / hour
(4 Reviews)
2.7
SMurmu

Wish you a good day, I have gone through your job post and come to know that you are looking for reliable Web Developer/SEO/Social media Marketing/Data Entry/Web Research/ Data Research and data Uploading specialist. More

$3 USD / hour
(3 Reviews)
3.0
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

$5 USD / hour
(5 Reviews)
2.4
ragulnishanth

Hi there, I'm replying to you after reading your complete profile and requirements. I'm eligible for your work and skill to complete your task quicker. I will work for you 8 hours per day completing your work quicke More

$20 USD / hour
(5 Reviews)
2.2
AlaaAhmed010

Good. B.

$5 USD / hour
(0 Reviews)
0.0
$3 USD / hour
(0 Reviews)
0.0
devshikary

Hi, I'm interest to do this offer, i have 5 years experience, thanks Devdas Shikary

$5 USD / hour
(0 Reviews)
0.0
Noman418

Hi I can do your task with accuracy and honesty in prescribed. Waiting for your response

$2 USD / hour
(0 Reviews)
0.0
NoSonforhim

I have 20 years in Database Developing, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, and MS SQL server

$5 USD / hour
(0 Reviews)
0.0