Macro Needed - Move data to worksheet based on criteria

Good Day,

I am wondering if someone can help me write a macro to move data from one worksheet to the next. Eliminating rows that have met a specific criteria.

I have attached the workbook.

Basically I am looking to move January data to February at the end of the month. Unless the final column in the row (AO) is marked yes.

Thank you for your help.
BJ

Hi
this macro will copy everything on the active sheet and paste it onto the next sheet, then delete every row which has the value "yes" in column AO

Please Login or Register  to view this content.

Does this do what you want?

Please Login or Register  to view this content.

NickyC

Thank you this code works great. There is just one hiccup.

The data on the active sheet is entered into the cells using a combo box. When the data is transfered to the next sheet the rows that are removed as per the criteria delete but, the combo boxes remain and appear under the combo box for the row above.

Would you have suggestions for correcting this?

BJ

ok, try this variation - it should delete all the shapes in the row that you delete

Please Login or Register  to view this content.

Thank you - works perfectly.