I'm very new to VBA Code.
I have a file that has 2 worksheets, WorkingAssignments and CompletedAssignments, I need all rows in WorkingAssignments to be transferred, (if possible by Command Button) to the CompletedAssignment sheet once the word in Column L shows TRUE ('true' means assignment has been completed).
Could I copy (any completed assignments) over to the CompletedAssignment sheet and under the occupied row(s) to the next vacant row (available).
For example, 'assignment 1' was completed and transferred over, then 2 days later 'assignment 2 & 3' were completed... I would need '2 & 3' to transfer over and below 'assignment 1'.
Hope this makes sense and thank you to everyone and anyone who can help me with this.
Bookmarks