VBA/Macro Help Needed
 

Pasha,

Attachments are disallowed in these groups. It's likely that no one will
open it. Describe the problem in enough detail, and we'll regail you with
solutions. Some may work!

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Pasha" wrote in message
...
I have modified MS's template (attached) to use for employee absence and
punctuality tracking. My company allows no more than 3 unexcused absences
during any 6 months period. Same applies to tardiness. I would like to
have a macro that will track that automatically as I enter "T" or "U" in
the
spreadsheet. Any ideas would be greatly appreciated.

Pasha

VBA/Macro Help Needed
 

Sorry,
Here is a spreadsheet I'm working on. For each Unexcused absence I would
enter "U" for the date it happened on, or "T" for tardiness. I would like
to have 3rd occurrence within 6 months to either look different or to have
some kind of alert. Hope this is clear.

"January" is B4

Attendance Totals PTO
Tardy Unexcused Excused Balance
January 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 31 0 0 0 20

February 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 0 0 0 20

March 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 31 0 0 0 20

April 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 0 0 0 20

May 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
26 27 28 29 30 31 0 0 0 20

June 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
26 27 28 29 30 0 0 0 20

July 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
26 27 28 29 30 31 0 0 0 20

August 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 31 0 0 0 20

September 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 30 0 0 0 20

October 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 31 0 0 0 20

November 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 30 0 0 0 20

December 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 30 31 0 0 0 20




Pasha

"Earl Kiosterud" wrote in message
...
Pasha,

Attachments are disallowed in these groups. It's likely that no one will
open it. Describe the problem in enough detail, and we'll regail you with
solutions. Some may work!

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Pasha" wrote in message
...
I have modified MS's template (attached) to use for employee absence and
punctuality tracking. My company allows no more than 3 unexcused
absences
during any 6 months period. Same applies to tardiness. I would like to
have a macro that will track that automatically as I enter "T" or "U" in
the
spreadsheet. Any ideas would be greatly appreciated.

Pasha

VBA/Macro Help Needed
 

Pasha
I gather that you have a row for January (row 4?) and another for
February and so forth. Where do you put the T or U? If you wish, send me a
file with a sample of what you have. Remove "cobia97" from my email
address.
How do you want the notification to happen? Maybe a message box telling
the name of the person and whether it's the T or the U that has occurred 3
times in the last six months? Or just color the current cell? Is this one
sheet per person?
HTH Otto
"Pasha" wrote in message
...
Sorry,
Here is a spreadsheet I'm working on. For each Unexcused absence I would
enter "U" for the date it happened on, or "T" for tardiness. I would like
to have 3rd occurrence within 6 months to either look different or to have
some kind of alert. Hope this is clear.

"January" is B4

Attendance Totals PTO
Tardy Unexcused Excused Balance
January 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24
25 26 27 28 29 30 31 0 0 0 20

February 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 0 0 0 20

March 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 31 0 0 0 20

April 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27 28 29 30 0 0 0 20

May 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25
26 27 28 29 30 31 0 0 0 20

June 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25
26 27 28 29 30 0 0 0 20

July 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25
26 27 28 29 30 31 0 0 0 20

August 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24
25 26 27 28 29 30 31 0 0 0 20

September 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
23
24 25 26 27 28 29 30 0 0 0 20

October 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24
25 26 27 28 29 30 31 0 0 0 20

November 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 30 0 0 0 20

December 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
24 25 26 27 28 29 30 31 0 0 0 20




Pasha

"Earl Kiosterud" wrote in message
...
Pasha,

Attachments are disallowed in these groups. It's likely that no one
will
open it. Describe the problem in enough detail, and we'll regail you
with
solutions. Some may work!

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Pasha" wrote in message
...
I have modified MS's template (attached) to use for employee absence
and
punctuality tracking. My company allows no more than 3 unexcused
absences
during any 6 months period. Same applies to tardiness. I would like
to
have a macro that will track that automatically as I enter "T" or "U"
in
the
spreadsheet. Any ideas would be greatly appreciated.

Pasha