worksheets

[Liana]

Can anyone advise me how to best lay out my worksheet. I need to record
daily, weekly & monthly figures & times . Each days info takes up alot of
space so I have given every day a new sheet & made a weekly summary sheet at
the beginning , but that only gives me 1 week out the month.
How can i get the other weeks in with monthly totals , if i put 31 days on 1
sheet it is far too cluttered & hard to visualize
Help !!

 

[JR Hester]

Sounds like your scenario would benefit from a pivot table to summarise your
data. Debra Dalgleish has a very helpful explanation and tips at teh
following website. I solved a similar nightmare using a dynamic named range
as teh source for a pivot table. hth

http://www.contextures.com/tiptech.html