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

- - Latest reply: rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- 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
See more 

1 reply

Best answer
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
753
1
Thank you
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

Say "Thank you" 1

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

CCM 6065 users have said thank you to us this month

But I need the VBA code for that.

Thank you,
Issa
rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
753 -
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

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