thank you for the assistance. I'll give it a try.

rgarber50 wrote:
Lenore
I am not one of the Excel gurus but I would try using the excel
subtotal feature.
First I would add a column to the left of A1 that was titled something
like week #. Then I would use the one worksheet for the whole month.
Each date gets the particular week#.
Select the whole list including headers
From the Excel menu - Data - subtotal
At each change in: Week#
be sure to check off each field you want to have subtotaled.

You'll see the outline symbol to the left that will allow you to hide
or show whatever detail you want. You can then format your outline as
you want.

Check out the excel help on subtotals - and Exceltip.com in the excel
tips section has a good number of hints.

Hope this helps.
Richard

Lenora via OfficeKB.com Wrote:
Form is set-up like a table

[quoted text clipped - 27 lines]
down
a line?



--
Message posted via http://www.officekb.com