Copy Unique Values To Another Sheet

[Paul911]

Hello,

Just wondering if someone could help me create a macro for the following attached file;

My first sheet is a summary report with 4 columns and row one has the heading.
My second sheet is the results I would like to have. I manually entered these results but would like them automated.

Ultimately in my results sheet, I would like the city name, with a formula to add all the tasks from sheet 1 and divide it by 60 which would give me the total number of minutes.

Could someone please help?

Thank you.
Paul

[martindwilson]

just get a list of unique locations in col a of sheet 2
then
=SUMIF(ReportQueryRequestsEmbeddedView!A:A,A2,ReportQueryRequestsEmbeddedView!D:D)/60
to get list of unique locations
use advance filter /unique