farnuckl said:Yogi, thanks. That gives me what I need. (It'll just take me a week to figure out what it does exactly)
Aladin, yours works for the january page but it needs to be generic so it can work for all the months.
2004MIS.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | |||
104 | ||||||||||||||
105 | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Total | |||||
106 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | ||||||
107 | Z | 1/24 | ||||||||||||
108 | AA | 1/25 | ||||||||||||
109 | 35 | 75 | 28 | 27 | 691 | AB | 1/26 | |||||||
110 | 26 | 58 | 21 | 22 | 525 | AC | 1/27 | |||||||
111 | AD | 1/28 | ||||||||||||
112 | 646 | 1382 | 700 | 636 | 16884 | AE | 1/29 | |||||||
113 | 475 | 1043 | 555 | 488 | 14302 | AF | 1/30 | |||||||
114 | ||||||||||||||
115 | 681 | 1457 | 728 | 663 | 0 | 17575 | ||||||||
116 | 501 | 1101 | 576 | 510 | 0 | 14827 | ||||||||
jan |