Move row from one Table in one Sheet to another Table in another Sheet based on cell value

Hi!

I'm trying to figure out how to move a row from a table in one sheet to another table in another sheet based on a value (done=1).
If I enter 1 (shown as done) the row is moved to another sheet, however - the row is added below the table in the other sheet that I have created, and not inside the table. How do I fix this?

Please Login or Register  to view this content.

Apart from the question above, I would like to sort the rows (in the first table) based on the priority. I have already sorted them based on date with the sorting method in Excel so I can't use that method again if you understand what I mean.
What I want to achieve is something as shown below.

Task 1 Priority High Date: 24 April
Task 2 Priority High Date: 27 April

Task 3 Priority Medium Date: 24 April
Task 4 Priority Medium Date: 28 April

Task 5 Priority Low Date: 24 April


And also! I can't seem to save the macro. Everytime I re-open the Excel-file the macro code is gone. Can somebody tell me whats wrong?

Thank you in advance!