i have a worksheet broken into 26 weeks, each broken into 7 days. so their
all the same. i want to display each week on a report sheet, but only in 4
weeks (1 month) group. i tried a pivot table, but i can't get the value area
to display my values. It only displays '1' in each cell. Would i be better to
have a command button or scroll button to flick thru the weekly groups. i.e.
each click displays the next week in a view.

--
Browny