Greetings all!
I'm sure what I'm about to post has been covered somewhere, but my searches have come up blank and I can't seem to modify the solutions to similar inquiries to meet my needs. I am using Excel 2003.
I am using the attached workbook to track my work progress on various projects. There are four sheets in the workbok, "Tasks", "Reports", "Completed Tasks", and "Settings".
I want the ability to move rows from the "Tasks" sheet to the "Completed Tasks" sheet by clicking the "Move Completed Tasks" button. I am interested in moving columns B-K for all rows that are marked as "Completed" in column G to colums B-K in the "Completed Tasks" sheet. At the same time, I want all completed tasks removed from the "Tasks" sheet without messing up the formatting (such as formulas and gridlines). I'm not concerned about the formating on the "Tasks Completed" sheet, so long as the layout is the same as the "Tasks" sheet. Additionally, the "Completed Tasks" sheet needs to add newly completed tasks below the last completed task to make an ever growing list of work completed.
Any help is greatly appreciated!!!!
-Jake
Bookmarks