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.