Downloading data from Internet explore

[venkateshr]

Hi ALl,

I want automate a report in my office using VBA could some please help me

Need to download the data from Internet explore from my company website using a VBA and then do the aging calculation based on created time - today and prepare the category then a Pivot needs to be inplace.

Sample data is mentioned below for reference. Last 2 Coloumn is manually updated by me using formula.
Ageing Formula : =NOW()-E3
Aging Range Formula : =IF(AND(J3>=7,J3<14),">7",IF(AND(J3>=14,J3<21),">14",IF(AND(J3>=21,J3<30),">21",IF(AND(J3>=30,J3<45),">30",IF(AND(J3>=45,J3<90),">45",IF(J3>=90,">90","<7"))))))

Assignee	Ticket Type	Ticket ID	Assigned Group	Open Date	Open Duration (days)	Ticket Status	Update Date	Ticket Title	Ageing	Ageing Range
Anthony Sathish	Request Task	R558732-002	ITS Voice Engineering	9/12/2014 9:56:57 AM	5	ordered	9/16/2014 11:21:19 AM	Please create phone extension for new hire Aaron Hauptman - phone extension must be 429 Aaron is a	5.6	<7

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

Thanks in advance for your time and help.