Copying/Pasting Rows/Columns based on content

Good Afternoon!

I need some serious help with this macro that I am trying to write.

I have attached the spreadsheet that I am working on. I was trying to write a macro that would cut all of the rows that have "Duplicate claim/service." in column L and paste them into a new worksheet within this workbook. I would also like to cut all of the rows that have a "Y" in column M and paste them into the same worksheet as the "Duplicate claim/services".

This is a report that is generated daily, the number of rows will vary from day to day. I need this macro to be able to capture ALL of the Duplicate claim/services and ALL of the Y's regardless of how many rows there are in the worksheet.

This report is a medical claim denial report, all of the "accounts" have to be reviewed EXCEPT for the Duplicate claims and the ones that are marked "Y" for worked.

I hope this makes sense and I hope someone might be able to help me.

Thanks,

Laura S.
lmsloman@yahoo.com