Food for thought...

You might find it easier to manage if you add 12 month columns to the
right og AH, and collect monthly data there. This, of course, would
require each entry to include a date so each month column could collect
only its entries.

Alternatively, you could continue using a 'working' sheet month to
month, but use only one sheet for the current fiscal year where you
collect data for each month over 12 columns. This will still provide
familiar task processing but allow you to store multiple years in a
single file (1 sheet per fiscal year).

If you organize the headers for the month columns as 3 character
abbreviations then you can store the current month on the 'working'
sheet and use a macro to 'post' the data to its respective column on
the fiscal year sheet, clear the 'working' sheet, and set the next
month so you're ready to go.

The macro can also handle the highlighting of consecutive days.

-OR-
I'm assuming you also want to record the actual days (on fiscal sheet)
that someone is sick, and so you could also set up day rows for each
month and worker columns on a single worksheet for each fiscal year.
Then everything is in one place and you could use outlining with totals
for each month in the top row so you can see them when the group is
collapsed. I do something similar where I have a sheet set up for each
day of a fiscal year on contiguous rows, and the tracking criteria in
columns starting in "C". Column "A" contains formulas to automatically
populate the entire sheet with dates when the fiscal start date is
entered in month1. Column "B" is set up to display the 3 character
abbreviation for the day of its respective value in column "A". The
days are configured same as a calendar, so if your fiscal year starts
April 1st then you'd enter 4-1 into the 1st cell of month1 because this
year April 1st is a Sunday. If it was a Tuesday then you'd enter 4-1 in
the 3rd cell of month1, leaving the previous cells blank. Feb is
configured to leave the 29th cell empty if not a leap year.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion