I have quite a few sets of stats sheets that I need to update each month. That is I need to re-date them and delete the entries for the previous month. Is there any way I can autmate this? I have attached a sample from one of the sheets. I actually tried to upload this earlier but think it failed? Apologies if it did not.
Thank you in advance
Alex
Thank you in advance
Alex
Binding and Finishing White City September 2007.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | White City | MONTHLY TOTALS - September 2007 | Westfield | ||||||
2 | |||||||||
3 | Comb Binding A4 | ||||||||
4 | Comb Bind | Comb Bind | Comb Bind | ||||||
5 | A4 (6-18mm) | A4 (19-37mm) | A4 (37mm+) | ||||||
6 | 03-Sep | ||||||||
7 | 04-Sep | ||||||||
8 | 05-Sep | ||||||||
9 | 06-Sep | ||||||||
10 | 07-Sep | ||||||||
11 | Total - Week 1 | 0 | 0 | 0 | |||||
12 | |||||||||
13 | Comb Bind | Comb Bind | Comb Bind | ||||||
14 | A4 (6-18mm) | A4 (19-37mm) | A4 (37mm+) | ||||||
15 | 10-Sep | ||||||||
16 | 11-Sep | ||||||||
17 | 12-Sep | ||||||||
18 | 13-Sep | ||||||||
19 | 14-Sep | ||||||||
20 | Total - Week 2 | 0 | 0 | 0 | |||||
21 | |||||||||
22 | Comb Bind | Comb Bind | Comb Bind | ||||||
23 | A4 (6-18mm) | A4 (19-37mm) | A4 (37mm+) | ||||||
24 | 17-Sep | ||||||||
25 | 18-Sep | ||||||||
26 | 19-Sep | ||||||||
27 | 20-Sep | ||||||||
28 | 21-Sep | ||||||||
29 | Total - Week 3 | 0 | 0 | 0 | |||||
Westfield |