Please see the attached spreadsheet.
I have a Macro that will move a highlighted row from one of the Dept sheets to the archive page.
I works but it erases the last row in the archive file.
I want to be able to add row underneath the previous archive entry, without deleting anything in the archive.
Thanks in advance for any help.
Bookmarks