Hi avk,

Take all that date stuff off the top and have a single date in Col G. In Col H have a Number that came in (bought?).
Get rid of the grouping (outline) stuff on the left of your sheet1 also.

Use you existing table as a validation lookup table to fill in a table sheet.
The table needs these columns
PartNo, Desc, Series, Type, Date, Quantity

Then do a Pivot table by date to count by month, day etc
You can also filter by PartNo or by Type or Series etc.

I suggest you look into the DTPicker for entering your dates. I'd also try to automate some way to quickly add/find parts.

How do you know what comes across your desk. Do you have the PartNo or do you have to look up the Description? Would filtering by Type let you find the part faster?