Hi all,
I found examples that get close to what I need, but can't quite adjust the code to finish it off (due to my lack of VBA knowledge). High level, what I'm trying to do is create a macro (button) that when clicked moves all rows that have "Complete" in column "E" to different worksheet named "Archive". The major hurdle i kept running into was if I ran the macro again, it would overwrite the existing data on the "Archive" worksheet. I want it to be, well, an archiveand retain existing data, so it should paste in the first empty row. Also had issues with attempting to maintain two rows of headers/titles.
Attached is a sample workbook.
Let me know if additional info is needed and thanks for any help!
Bookmarks