Previous Topic Next Topic

Cut Entire Row To Another Sheet Based on Cell

Closed
issa - Jun 2, 2011 at 12:16 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2011 at 06:50 AM
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

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Jun 2, 2011 at 05:51 PM
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
issa
Jun 3, 2011 at 12:34 AM
But I need the VBA code for that.

Thank you,
Issa
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Jun 3, 2011 at 06:50 AM
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
0