I have two pages one is called Due and one is called Completed. If one of the tasks in the Due sheet is marked completed it should move only the values from that line and exclude columns C, D, F to the Completed sheet. It should also work in reverse so if on the Completed page I select reschedule it will move the values back to the Due sheet. I have this a good portion completed however I cant figure out how to exclude the columns, copy & paste only the values, remove data from page after it is moved, and get it to insert into the table it is inserting data after the table. Would also to be nice if when it was moved from Due to Completed it put the date it was moved as an archived date.
Here is a copy of the workbook
Thank you for looking and hopefully someone can assist with this providing it isnt too much work.
Bookmarks