I have a time sheet within a Workbook that has thousands of rows of data and in order to simplify I wish to run a macro across it to reduce it from daily records to weekly.
I was thinking of a macro to loop through the daily records but ame unstuck conceving the formula to sum daily records for either the same person or the same job.
Each record has a name of person, a job name and number, a time in hours, a date and a value charged with potentially multiple occurrences of the name and job occurring within the proposed summary week.
For example on a daily basis I may have
John - Tree-hugging - 1256 - 2.5 - 1/0818 - $125
Baza - Tree hugging - 1256 - 1.5 - 1/08/18 - $60
John - Perenials - 1244 - 8.0 - 26/07/18 - $85
John - Tree-hugging - 1256 - 4.0 - 3/08/18 - $165
Which I want to change by way of macro everytime we load new time sheet data to a weekly basis:
John - Tree-hugging - 1256 - 6.5 - week 31 - $290
John - Perennials - 1244 - 8.0 - week 30 - $85
Baza - Tree-hugging - 1256 - 1.5 - week 31 - 60
I would appreciate any help and direction form the forum - many thanks in advance.