Just wondering how you would do this in excel?

Must you use a macro?

And if you do what are the steps required to create a macro for archiving?

Ty in advance for any replies.