MrExcel Episode 1903

[korndoll]

‘How To Automatically Move Rows In Excel When Marked As Paid’​

Hi,

This ran flawlessly, however it does not delete the row in sheet 1, it essentially makes a copy of the row in sheet 2. I’d like to have more of a ‘move’ effect. Is there a way to modify it? I think it may have something to do with the highlighted piece

Thank you!

 

[Joe4]

Welcome to the Board!

If you want to delete the original row, try adding this block of code just before the first "End If" line:

    Application.EnableEvents = False
    Rows(FR).Delete
    Application.EnableEvents = True

 

[korndoll]

Welcome to the Board!

If you want to delete the original row, try adding this block of code just before the first "End If" line:

    Application.EnableEvents = False
    Rows(FR).Delete
    Application.EnableEvents = True

Thank you so much Joe4!!!

 

[Joe4]

You are welcome.
Glad I was able to help!