Hello,

Was reading up on this and i'm thinking of merging but the i saw something about advanced filters and thought i'de turn to the boards!

Corporate Action History Master.xlsx

What i was hoping was that automatically when "Response deadline date" [G] is past todays date by 90 and "Actioned" [H] = "Yes" that the entire row be cut across to Archive.

If had some success finding code to "Archive" based on a text value ("YES") but nothing on date/time...

Any thoughts please?

Links to any known threads also welcome please