Hi I want to create a macro which will cut every row that is marked as 'yes' in the 'completed' collumn on the 'CMP' sheet. Then paste these into the 'Completed Actions' sheet. I've tried different codes but cannot get the data to paste in the correct rows. I need to data to paste in the next blank row.
I have attached screenshots of the sheets so that makes more sense.