Downloading data from Internet explore

venkateshr

New Member
Joined
Oct 22, 2013
Messages
26
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"))))))
AssigneeTicket TypeTicket IDAssigned GroupOpen DateOpen Duration (days)Ticket StatusUpdate DateTicket TitleAgeingAgeing Range
Anthony SathishRequest TaskR558732-002ITS Voice Engineering9/12/2014 9:56:57 AM5ordered9/16/2014 11:21:19 AMPlease 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.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,109,448
Messages
5,528,804
Members
409,837
Latest member
karnasrinivas
Top