i dont know the answer to your question i once tried the looking myself
the most i came up with was autofilter on date until i stumbled on
freeze panes. Not sure if you know this or not but you can see how it
works just scroll using the horizontal bar. and the weeks will
disappear but the totals and sums will still work. Click on window
freeze panes make sure you select a column first or row however


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=547727