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.
Bookmarks