Thread: Macro to Copy Rows with Certain Condition to another Sheet?

Hi, I made a workbook for entering Purchase Orders that computes the efficiency of the Order Entry Cell of my company. There is a separate sheet for each month and some of the purchase orders are going to have delays, I have put in a column with a drop down list to indicate what type of delay that purchase order is facing. I would like to have a macro that would search through all of the monthly sheets and copy those rows that have delays associated with them at the time, and put them in another sheet that I have called right now DeliveryNewspaper. The columns I would like to have copied would be A through H. Any help would be appreciated.

Thank you in advance.

I've written a macro to update that for you. I've had to stick with the mis-spelt "DelieveryNews" worksheet name as the workbook is locked, however you should be able to change that yourself in the macro.

Let me know if there are any issues/concerns.

Sorry, just a note: Columns A and F of the DelieveryNews sheet should be formatted as date and everything will look right.