Cut row in Sheet1 when a Cells Value change to "Closed" and paste in Sheet2 incrementally

Hello,

I'm new in this forum, I've the following question:

I want to create a program in able to cut the row when the value "Closed" is selectioned, this row will be paste in Sheet2 incrementally.

Can you help me with some VBA code?

Thank you!

Kindly

Degiol

PS: Attached the file

Hi Degiol. There is no data in the "To DO List" sheet.

Hi Degiol. There are a couple of ways to accomplish what you want. The solution I have suggested uses a Worksheet_Change macro which is located in the worksheet code module. The macro is activated when you select "Closed" in column F of your "Open AP's" sheet. When you select "Closed" the row is copied to the "Closed Projects 2015" sheet and then deleted from the source sheet. In each row in the "Open AP's" sheet, column F must be the last cell completed. So fill in your data in columns A to E and column G and then make your selection in column F. Click here to download your file and let me know if this works for you. I've just entered some generic data for testing.

My pleasure. Ciao.