Reading unique values based on multiple criteria

I am working on a budgeting sheet and need to be able to manipulate the spreadsheet.

Capture.PNG

Based on this snapshot of the spreadsheet I need to be able to total the numbers for each unique period, project, and craft and then populate a new tab with records based on those unique totals.
I am very new to Visual Basic and would appreciate any help that I can get.

Thanks!

First off I would arrange your date tracking vertically in your worksheet,
this will allow many ways to manipulate your data.

then I would recommend looking at pivot tables.
You can define what criteria you want to chart and what range specifics.
They very powerful and somewhat simple to setup, there are many help pages devoted to them.

If you are determined to use vba there are methods for that as well, but I would still encourage rearranging you data to be vertical sorted by date

Date	Project	Craft
March 15	1	A
March 15	2	B
April 15	2	A
April 15	3	A
April 15	3	B
May 15	4	A
May 15	4	B
May 15	5	A

pivotTest2.jpg
this sums the crafts by project number

In this situation a client will be inputting the total number of persons per time period, per craft, and per project. I need to separate it out and populate another sheet with a list of the total number of people per distinct period, craft, and project. I have attached the full spreadsheet if this gives you a better idea.

Thanks for the help so far!

Example.xlsx