scraping website using vba excel please help

[dinesh1master]

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


[TABLE="width: 978"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Category name[/TD]
[TD]Job descriptions[/TD]
[TD]Location[/TD]
[TD]date[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]Deloitte - Corporate Finance Role (1-3 yrs)[/TD]
[TD]Mumbai[/TD]
[TD="align: right"]7/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]TUI India - AM/DM - Credit Control (3-5 yrs)[/TD]
[TD]Delhi/NCR[/TD]
[TD="align: right"]6/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]Credit Agricole - Manager - Taxation (7-10 yrs)[/TD]
[TD]Mumbai[/TD]
[TD="align: right"]6/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]Zomato - Manager - Corporate Accounting & Consolidation - CA (5-10 yrs)[/TD]
[TD]Delhi/NCR[/TD]
[TD="align: right"]6/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]L&T Financial Services - Area Collection Manager - Consumer & Auto Finance (6-11 yrs)[/TD]
[TD]MP/Indore[/TD]
[TD="align: right"]5/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]L&T Financial Services - Senior Credit Analyst - SME (5-10 yrs)[/TD]
[TD]Delhi/NCR[/TD]
[TD="align: right"]5/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]L&T Financial Services - Area Manager - Retail RCU (2-7 yrs)[/TD]
[TD]Tamilnadu/Trichy[/TD]
[TD="align: right"]5/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]L&T Financial Services - Credit Analyst - SME (1-4 yrs)[/TD]
[TD]Delhi/NCR[/TD]
[TD="align: right"]5/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]Ola Group - Senior Manager/Manager - Credit Analytical Modeler - Auto Loan (9-11 yrs)[/TD]
[TD]Bangalore[/TD]
[TD="align: right"]4/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]Deloitte - Manager - Integrated Due Diligence - Business Intelligence/Forensic (5-10 yrs)[/TD]
[TD]Delhi/NCR/Mumbai[/TD]
[TD="align: right"]4/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]Leader - IndAS/IFRS Conversion - Audit - CA (4-12 yrs)[/TD]
[TD]Mumbai[/TD]
[TD="align: right"]3/8/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]InteQuant Advisors - Sr Associate/VP/AVP - Investment Banking - Chennai Candidates (4-10 yrs)[/TD]
[TD]Chennai[/TD]
[TD]31/07/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]Flipkart - Manager - Business Finance (3-6 yrs)[/TD]
[TD]Bangalore[/TD]
[TD]31/07/2015[/TD]
[/TR]
[TR]
[TD]Banking & Finance Jobs[/TD]
[TD]Asian Paints - Management Trainee - Accounts (1-2 yrs)[/TD]
[TD]Mumbai[/TD]
[TD]31/07/2015[/TD]
[/TR]
</tbody>[/TABLE]


Please follow below point while automation this task

[TABLE="width: 791"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]1[/TD]
[TD] Open Url links as Banking & Finance jobs and other as screenshot sales & marketing
[/TD]
[/TR]
[TR]
[TD="align: right"]2
[/TD]
[TD]I want output data between two dates. Macro take input date range from excel sheet.[/TD]
[/TR]
[TR]
[TD="align: right"]3
[/TD]
[TD]Data should come above format in excel sheet[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD] macro should be avail to find jobs descriptoon in all pages according to date range.
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 489"]
<colgroup><col width="111"><col width="378"></colgroup><tbody>[TR]
[TD="class: xl65, width: 111"]Url Links[/TD]
[TD="width: 378"]http://www.iimjobs.com/c/banking--finance-jobs-13.html[/TD]
[/TR]
</tbody>[/TABLE]