VBA code that can get required data from excel sheet

[alialimian12]

Need web data in excel sheet automatically
https://www.zacks.com/stock/quote/AA?q=aa?q=AA
https://www.zacks.com/stock/quote/AA/detailed-estimates
Dear Members
I need to zacks data in excel sheets automatically
Then I need this table data in readable Form
Like from this table

Next Report Date	1/23/18
Current Quarter	1.24
EPS Last Quarter	0.75
Last EPS Surprise	-4.00%
ABR	1.59

<tbody>
</tbody>

I want not all values from above table. I need some values that are explained in below paragraph
The company expects to report next earnings on 1/23/18. Zacks Expert says that the company estimated to report current quarter earnings of 1.24. AA reports earnings of XXXX in last quarter earnings report
I need your help

 

[Macropod]

Cross-posted at:
https://www.excelforum.com/excel-pr...el-sheet-and-word-document-automatically.html
https://www.excelguru.ca/forums/sho...e-that-can-get-required-data-from-excel-sheet

Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[alialimian12]

Sorry Now i mentioned the cross posting
I posted the same issue on following forum also
I need Urgent solution therefore posted on these forum also
https://chandoo.org/forum/threads/need-web-data-in-excel-sheet-automatically.36656/
https://www.excelforum.com/excel-pr...-word-document-automatically.html#post4799918