I am not familiar with excel that much and would really appreciate help from gurus here. I am attaching caption of an excel workbook, data shown is in a sheet call log
exel.jpg

or look at the image here http://webquest.arthritis-research.org/images/exel.png

In Summary Sheet i want user to input two dates in G1 and G2 cell , use that as start data and end date
and display data in tables for the following in the summery sheet

Defects total by clock#
Defects total by Type
Defects total by Job#
Defects Total by Product Type

I have no clue how would that work ? I assume you enter two dates and hit enter or may be a button that run some macro

Thanks for any quick help