Cut Entire Row To Another Sheet Based on Cell Closed

Question

Hello Dears,

If any one can help me.

I have 2 excel sheets, Sheet1 "All Invoices" and sheet2 "PAID Invoices".

In sheet1 I have several columns filled in data from (A:S), but in column "S" is drop list menu and one of the option in that list is "PAID".

So, what I need is: when I select the option "PAID" in column "S" in Sheet1,
1.	Automatically that entire row to be cut and pasted in sheet2, but please note that everyday I have many paid invoices, so I need to keep all those pasted in Sheets2 as history not to be OVERWRITTEN over each other.

2.	Those rows that already cut in sheet1 to be deleted also.

Thanks in advance for any kind assistance.

Best regards,
Issa

rizvisa1 · Answer

You can use worksheet event

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

However, I would you suggest you do is a batch process. By that I mean, update all cells as you want. Once you want to delete and paste, run the macro

Cut Entire Row To Another Sheet Based on Cell

1 response

Similar discussions

Subscribe To Our Newsletter!