Automatically Clear Rows When Condition Is Met

I've got a workbook (attached) with a "summary" sheet & 2 detail sheets for tracking vacation time used, and I need to make it automatically clear out an employee's "used" vacation hours automatically on their anniversary date.

Can anybody help me please? I've had no luck thus far & "the powers that be" are really getting on me for this now - Thanks in advance for any help!

Don't duplicate posts, bump the original. If you haven't received an answer maybe you need to explain more clearly and/or attach an example.

You don't "clean up" the original post, you add a new post to it with more explanation & this will also bump it up the forum.

I looked at the example but also could not tell when the anniversary date occurred.

Where are the vacation days stored?

You seem to allocate vacation hours according to years from the hire date using the datedif function. How would you clear this?

Anniversary date would be a complete year (or x number of complete years) from the "Hire Date" in column C on the Summary sheet. On row 3 for example, the anniversary date this year would be 11/7/09, since the hire date is 11/7/07.

I've updated my example where I added some vacation time used to the first employee, so it is now deducting on the summary sheet & showing 8 unused hours; hopefully that will give a better idea of how everything's playing together. What I need is to set it up so it will automatically reset those unused hours on 11/7 (in other words, clear the data entered for that employee on the 'Vacation Time' sheet) because they will have earned another week of vacation & their unused time doesn't carry over.

Or maybe I'm going about this the wrong way?

I've figured that out, but we need to check for an anniversary date. This will vary because of lap years and the date may not be a workday in subsequent years.

I can match the week numbers using VBA, but then you have merged cells in the data sheets which make deleting the data more difficult. Are the names & rows fixed for each employee i.e. the first employee on the summary sheet will have the records in Row 5 of the data sheet?

This should do it, add some hours to the Vacation sheet for some dates that will be anniversary and save the workbook. Open it & the hours should clear

That looks like it's doing what I need it to - I've added to your reputation, thank you!

And this will not be thrown off when it comes time to add or remove employees?

Thanks for the feedback, the macro should work as long as you maintain the order of names in each sheet. It matches the current week number with that entered as Hire date, this should be close enough because as i said earlier the actual anniversary may fall at a weekend and not be picked up by matching the date.