Cut Entire Row To Another Sheet Based on Cell [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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
Related:

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

But I need the VBA code for that.

Thank you,
Issa
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
Do you really need a macro. I mean all you have to do is filter the sheet on "PAID". Copy all the visible rows and paste.
If you need a macro, see this, it is almost same as you

https://ccm.net/forum/affich-595175-needed-a-vba#p595274