Cut, paste from sheet 1 to sheet 2 on Yes No criteria

[gav119]

Hi Im struggling to create a macro to cut a row from my "Current" sheet to my "Completed" once completed in the response to a "Yes or No" criteria
Row one contains Headings
Rows 2 to 13 contain the data

Anyone have any ideas or a code that would do this? i have created a userform button to do this but i need it to open automatically on the opening of the spreadsheet.

Thanks!

[JBeaucaire]

I would recommend you not use a button, but rather use an "activation" event macro that does it when the workbook opens, and whenever you bring up the Completed sheet onscreen. Just looking at the sheet would bring over any items from the first sheet.

An AutoFilter would be the way to accomplish this, autofilter on row1, filter the "yes/no" column for the "yes" and then cut all visible rows to the completed sheet.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook. I can help create something specific for you with that.