VBA to move rows to new sheet

[Railea]

[Solved] Hi - I am not good at Excel but a bit of a Word guru. I have been asked to automate a worksheet so that when an invoice is paid (see column K) a date is input - what needs to happen is once a date is input into column K, the row would move to a new worksheet. Attached example has those rows highlighted pale orange.

I am hoping someone can help. Where I found myself really stuck was the information will get added to as new invoices are generated, and then once paid, will need to move to the bottom of the new sheet.

I attach workbook.

[MikeVol]

Hi @Railea.
Insert in Worksheet "Unpaid" Module next code:

Please Login or Register  to view this content.

I hope I understood you correctly. Good luck.

[Railea]

Thank you so much, Mike.

Kind regards,
Railea

[MikeVol]

Hello @Railea.
The above code cannot be used in another module, only in the worksheet module and no in another module!