Generating a suumary report from big workbook

[Mofokeng]

Hi All,

I would like to generate a daily summary report (with the option of weekly and monthly) from the big data the I have on Excel.


I the columns that I would like to be included in my summary report are:

1- Date (Column A).
2- CC name (Column B), I have more than 5 different CC names.
3- Team ID (Column C)
4- HH number (Column D)
5- HH members (Column E)
and the total of Columns D + E, as well as the total for both of the them by column.

Please see the attached file.


PS: The attached file is dummy file (not real values), as well as the order of the columns.


Regards,