I have a worksheet of data that I would like to create day of week trends without cutting and pasting... is there a way to have a sheet pull all the Monday columns, then tues col, etc?
thanks!
frank
thanks!
frank
Book3 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
1 | Day or Week Trend | ||||||||||||||||
2 | Wed | Base | Base | Base | Base | Base | Base | ||||||||||
3 | Sat | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | ||||
4 | LOCATION ROLLUP | 9/9/2006 | 9/11/2006 | 9/12/2006 | 9/13/2006 | 9/14/2006 | 9/15/2006 | ######## | ######## | ######## | ######## | ######## | ######## | ######## | |||
5 | item 1 | 261 | 2,571 | 2,811 | 2,925 | 3,000 | 2,989 | 255 | 0 | 2,451 | 2,798 | 2,951 | 3,049 | 2,987 | |||
6 | item 2 | 48.7 | 104.6 | 86.7 | 81.5 | 82.6 | 87.5 | 47.2 | 0 | 91.6 | 80 | 82.1 | 82.4 | 80.6 | |||
7 | item 3 | 5.36 | 24.58 | 32.41 | 35.9 | 36.34 | 34.16 | 5.4 | 0 | 26.77 | 34.97 | 35.93 | 37 | 37.06 | |||
8 | item 4 | 2.45 | 9.07 | 12.52 | 12.86 | 11.98 | 13.59 | 2.69 | 0 | 8.97 | 11.82 | 13.47 | 12.85 | 14.56 | |||
Sheet1 |