B
Ben
I have two worksheets: Report and Weekly Report. On the report I have the
data listed by days. Some days are five day work weeks and some can be up to
seven day work weeks.
Simple example below
Report
Date Failures
12/3 5
12/4 6
12/5 3
12/6 9
12/7 10
12/10 3
12/12 2
12/15 1
I want the weekly report to look like this:
Week Of Failures
12/3 33
12/10 6
I want to use macros for these examples.
Thanks
data listed by days. Some days are five day work weeks and some can be up to
seven day work weeks.
Simple example below
Report
Date Failures
12/3 5
12/4 6
12/5 3
12/6 9
12/7 10
12/10 3
12/12 2
12/15 1
I want the weekly report to look like this:
Week Of Failures
12/3 33
12/10 6
I want to use macros for these examples.
Thanks