scraping website using vba excel please help

dinesh1master

New Member
Joined
Jul 24, 2014
Messages
3
Banking & Finance Jobs, iim mba jobs, ecommerce, retail, business, development, manager, technology, healthcare, telecom, insurance, fmcg, media, bfsi, director, vp/avp, ceo/cfo, agm/dgm - iimjobs.com

Hi all,

Please find below data format for website scraping.please send me code on my email id dinesh1master@gmail.com


Category nameJob descriptionsLocationdate
Banking & Finance JobsDeloitte - Corporate Finance Role (1-3 yrs)Mumbai7/8/2015
Banking & Finance JobsTUI India - AM/DM - Credit Control (3-5 yrs)Delhi/NCR6/8/2015
Banking & Finance JobsCredit Agricole - Manager - Taxation (7-10 yrs)Mumbai6/8/2015
Banking & Finance JobsZomato - Manager - Corporate Accounting & Consolidation - CA (5-10 yrs)Delhi/NCR6/8/2015
Banking & Finance JobsL&T Financial Services - Area Collection Manager - Consumer & Auto Finance (6-11 yrs)MP/Indore5/8/2015
Banking & Finance JobsL&T Financial Services - Senior Credit Analyst - SME (5-10 yrs)Delhi/NCR5/8/2015
Banking & Finance JobsL&T Financial Services - Area Manager - Retail RCU (2-7 yrs)Tamilnadu/Trichy5/8/2015
Banking & Finance JobsL&T Financial Services - Credit Analyst - SME (1-4 yrs)Delhi/NCR5/8/2015
Banking & Finance JobsOla Group - Senior Manager/Manager - Credit Analytical Modeler - Auto Loan (9-11 yrs)Bangalore4/8/2015
Banking & Finance JobsDeloitte - Manager - Integrated Due Diligence - Business Intelligence/Forensic (5-10 yrs)Delhi/NCR/Mumbai4/8/2015
Banking & Finance JobsLeader - IndAS/IFRS Conversion - Audit - CA (4-12 yrs)Mumbai3/8/2015
Banking & Finance JobsInteQuant Advisors - Sr Associate/VP/AVP - Investment Banking - Chennai Candidates (4-10 yrs)Chennai31/07/2015
Banking & Finance JobsFlipkart - Manager - Business Finance (3-6 yrs)Bangalore31/07/2015
Banking & Finance JobsAsian Paints - Management Trainee - Accounts (1-2 yrs)Mumbai31/07/2015

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>


Please follow below point while automation this task

1 Open Url links as Banking & Finance jobs and other as screenshot sales & marketing
2
I want output data between two dates. Macro take input date range from excel sheet.
3
Data should come above format in excel sheet
4 macro should be avail to find jobs descriptoon in all pages according to date range.

<colgroup><col><col></colgroup><tbody>
</tbody>

Url Linkshttp://www.iimjobs.com/c/banking--finance-jobs-13.html

<colgroup><col width="111"><col width="378"></colgroup><tbody>
</tbody>
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,214,385
Messages
6,119,205
Members
448,874
Latest member
Lancelots

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top