attendance record HELP!

[Jenn K]

I have a spreadsheet set up to track employees attendance.
The problem is that our attendance policy is based on a
rolling 12 year calendar. I have the spreadsheet set up to
tally all the S (sick) functions, P (personal) functions,
and T (tardy) functions. But I cant get it to delete Jan
1, 2003 info on Jan 1, 2004 and so on for the entire year.
Can any one help???

 

[Otto Moehrbach]

Jenn
The first day of your current "year" will always be in the same row,
wouldn't it? IOW, when you add Dec 24, 2003 to the bottom of your data, Dec
24, 2002 would be in say A2, and you want to delete that row, Row 2.
Tomorrow you will add Dec 25 2003 and you want to delete Dec 25 2002. Well
Dec 25 2002 will be in Row 2 so you again want to delete Row 2. Am I right
or did I miss something?
All you need to do is delete Row 2. Use:
[A2].EntireRow.Delete
HTH Otto

 

[Guest]

Actually, my spreadsheet is set up something like this...

2003 1 2 3 4 5 (to 31) ..... sick personal tardy early out no call etc...
Jan
Feb
Mar
(all the way to dec)
2004
Jan
Feb
Mar
(all the way to dec)
Totals of S P T etc....
I have seperate spreadsheets made up for each of the 409 employees. Then each time someone calls off or is tardy etc... I put an S, P, T, NC, UEO in the appropriate day and month. Then in the S/P/T etc... columns I have a countif formula to count each of the "occurences:" that they receive. We have to keep a full year of call offs in their record, so I dont delete much of anything. For instance, I just deleted 2002 occurences and added the 2004 calendar to the bottom. I know it sounds more complicated then it really is, and I didnt create the first spreadsheet, it was designed by an x employee. And when one of our admin helps deleted the 2002 calendar and put in the 2004 we lost all the formulas. Anyhow before I start rambling, what I need is at the bottom in the Totals columns is that each S/P/T "occurence point" will fall off on a specific date. I dont want to manually have to go in on each day and delete someones point from the total at the end of the column. If you need more info to help me, please let me know. Thanks for the reply tho I really appreciate it.

Jenn K

 

[Otto Moehrbach]

Jenn
I can't follow that. If you wish, send me a sample file, not too big,
direct via email. Set it up to show me what you have on one day and what
you want to have on the next day. Include any other explanation you think
would help. Remove "cobia97" from my email address or it will go nowhere.
HTH Otto

Actually, my spreadsheet is set up something like this...

2003 1 2 3 4 5 (to 31)

...... sick personal tardy early out no call etc...

Jan
Feb
Mar
(all the way to dec)
2004
Jan
Feb
Mar
(all the way to dec)

Totals of S P T etc....

I have seperate spreadsheets made up for each of the 409 employees. Then

each time someone calls off or is tardy etc... I put an S, P, T, NC, UEO in
the appropriate day and month. Then in the S/P/T etc... columns I have a
countif formula to count each of the "occurences:" that they receive. We
have to keep a full year of call offs in their record, so I dont delete much
of anything. For instance, I just deleted 2002 occurences and added the 2004
calendar to the bottom. I know it sounds more complicated then it really is,
and I didnt create the first spreadsheet, it was designed by an x employee.
And when one of our admin helps deleted the 2002 calendar and put in the
2004 we lost all the formulas. Anyhow before I start rambling, what I need
is at the bottom in the Totals columns is that each S/P/T "occurence point"
will fall off on a specific date. I dont want to manually have to go in on
each day and delete someones point from the total at the end of the column.
If you need more info to help me, please let me know. Thanks for the reply
tho I really appreciate it.