Workbook with sheets Assigned and Completed. I want to be able to select a row from sheet Assigned (not always the first row) and move the data to sheet Completed in the next available row (archiving completed work). I want the selected row to then be deleted after it has been moved and any rows that were under it to move up so there are no empty rows. I've found many different variations but have not found one that does all of what I want. My sheet has 26 columns that need to be copied/moved.

I have a procedure to send an email to my group that has the Assigned information (different people have different pieces of the assignment) in a workbook that I am trying to clean up. I won't know if it works until I get the sheets thing figured out.

Thanks in advance for your help.