you might not need a macro for this job, it is not a difficult task, it may be solved with the right calculation formulas; check your file modified and attached; (i added a condition column in sheet 1, for use in summary sheet formula)

Attached Files

Copie a Date query.xls (39.5 KB, 11 views)