Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed :( | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
macro needed | Excel Programming |