Posts by Joker2111

Well, royUK thank you very much for the feedback. Clearly, I did not take into consideration how easy the worksheet would be for one to work in. I have made modifications and hopefully this one is better. I have also added data for the second 'test' employee. Ideally what I am looking for would be for the spreadsheet to remove any occurrences that are older than 1 year and once that is done both the first and second 'test' employees will be identical.

I do appreciate any and all help/advice that is given. I am just looking for an easier way to keep this spreadsheet up to date for around 500 employees.

[xpost][/xpost]

Crossposted: https://www.excelforum.com/exc…ent-data.html#post5574890

Hello,

I am needing assistance with creating a Macro that will look at the dates entered for an employee's sick occurrences and once an occurrence has aged past 1 year the macro will remove the entry and then move the entries that are less than a year old over. For reference on the spreadsheet I uploaded, the Macro would remove the first occurrence listed and then move the second and third occurrence over to the left and they would be the new first and second occurrence. I hope that is clear with what I am needing help with. If any additional information is needed please let me know.