[xpost][/xpost]
Crossposted: https://www.excelforum.com/excel-programm…tml#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.