D
dexterslabmi
Hello Friends
I am stumped right now. I have a series of large spreadsheet that I am
attempting to automate and here is a stripped doen look at one of them.
These sheets feed into a master sheet with all of the totals and
summaries that are calculated weekly.
Well one of the biggest headaches is at the beginning of the month is
the need to adjust the dates and the summary/totals columns. To added
insult to injury, my director recently requestd that the if there is a
SAT at the beginning of the month I have to add it to the totals for
the following week(every SAT). I have automated most of the steps....
however the path that I was going down does not support when there are
less than 7 days in the 1st week (which is every month this year except
2, hence my ???).
"=IF(ISERR(SUM(D8
14))=TRUE,"",IF(WEEKDAY(B14)=7,SUM(D814),""))"
A B C D E
1 Date Penetration Sales
2 8/1/2006 11% 5052
3 8/2/2006 21% 2869
4 8/3/2006 16% 4006
5 8/4/2006 11% 3015
6 8/5/2006 15% 4515 ???
7 8/6/2006 21% 4576
8 8/7/2006 17% 4292
9 8/8/2006 13% 4011
10 8/9/2006 5% 2559
11 8/10/2006 4% 3490
12 8/11/2006 13% 3244
13 8/12/2006 11% 3465 25637
14 8/13/2006 6% 3424
15 8/14/2006 7% 3757
16 8/15/2006 3% 3361
17 8/16/2006 5% 2164
18 8/17/2006 6% 3206
19 8/18/2006 5% 2559
20 8/19/2006 4% 3490 21961
Does anyone have any thoughts either with vba or a formula? I would
really like something more dynamic so I can use it for other columns
throughout this project...
Thanks in advance for your help,,,
I am stumped right now. I have a series of large spreadsheet that I am
attempting to automate and here is a stripped doen look at one of them.
These sheets feed into a master sheet with all of the totals and
summaries that are calculated weekly.
Well one of the biggest headaches is at the beginning of the month is
the need to adjust the dates and the summary/totals columns. To added
insult to injury, my director recently requestd that the if there is a
SAT at the beginning of the month I have to add it to the totals for
the following week(every SAT). I have automated most of the steps....
however the path that I was going down does not support when there are
less than 7 days in the 1st week (which is every month this year except
2, hence my ???).
"=IF(ISERR(SUM(D8
14))=TRUE,"",IF(WEEKDAY(B14)=7,SUM(D814),""))"A B C D E
1 Date Penetration Sales
2 8/1/2006 11% 5052
3 8/2/2006 21% 2869
4 8/3/2006 16% 4006
5 8/4/2006 11% 3015
6 8/5/2006 15% 4515 ???
7 8/6/2006 21% 4576
8 8/7/2006 17% 4292
9 8/8/2006 13% 4011
10 8/9/2006 5% 2559
11 8/10/2006 4% 3490
12 8/11/2006 13% 3244
13 8/12/2006 11% 3465 25637
14 8/13/2006 6% 3424
15 8/14/2006 7% 3757
16 8/15/2006 3% 3361
17 8/16/2006 5% 2164
18 8/17/2006 6% 3206
19 8/18/2006 5% 2559
20 8/19/2006 4% 3490 21961
Does anyone have any thoughts either with vba or a formula? I would
really like something more dynamic so I can use it for other columns
throughout this project...
Thanks in advance for your help,,,