Hello,

I am fairly new at macros, pretty much teaching myself as I work on projects assigned to me. I have this excel that I have created that holds off those who call in sick or absent to work for the day. The excel takes these entries and sends an email to their supervisor and such to be notified and tracked in our call center programs and also occurrences are tracked here. Occurrences are only kept on someones record for a year.

So this is what I am looking for. I need an automatic way to have the row of data, when a year is up, to move it to the archived tab; so that we can still see them if needed.

Here are specifics: The row of data is from columns A-J (could change). The date column is E. And the data starts on row 2 (first row is headers). The tab everything is orginially entered in is called "Call In's". The archive tab is called "OldEntries".

Any help would be greatly appreciated.
Thank you!