Hello,
I am new to VBA, and I was wondering if the following can be done. Basically, I need to extract a summary from a large data set (I have attached an example) into a separate sheet so I can export easily as a report.

The summary should add up the hours based on location, date and service. Some of the services are to be combined, in the example, you will notice that the hours for Domestic RRD and CTL RRD are added together for the same location and date.

Any help would be appreciated!
Thank you!



Location Date Service Hours
TYC 12/1/2017 Domestic RRD 2
TYC 12/1/2017 INTL RRD 7
TYC 12/2/2017 Domestic RRD 2.5
TYC 12/2/2017 CTL RRD 0.75
CAS 12/1/2017 Domestic RRD 3.5
CAS 12/2/2017 INTL RRD 9.5
CAS 12/2/2017 Domestic RRD 1
CAS 12/2/2017 CTL RRD 1.25





Output: Should be on next sheet

Location Date Service Hours
TYC 12/1/2017 Domestic 2
TYC 12/2/2017 Domestic 3.25
TYC 12/1/2017 INTL 7
CAS 12/1/2017 Domestic 3.5
CAS 12/2/2017 INTL 9.5
CAS 12/2/2017 Domestic 2.25