Macro to undo sub

Hi, I am looking for some code that would undo the below sub. The sub searches a table and pulls data of cells based on cell color. It continuously populates the Sheet "ALLmissed" and adds to the last used row in the sheet. I would like the undo to only undo the most recent update, and to keep the previous data that exists from previous times running the sub. I appreciate any help!

Please Login or Register  to view this content.

Why not Time/Date stamp your data, and create a macro that deletes data by referencing this?

That could work, I already have the time stamp written in:

Please Login or Register  to view this content.

Let's say I would want it to delete anything within the last hour...how would I go about doing that? Sorry I am pretty new to this.

Thanks!