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
Bookmarks