I have a workbook to track sales and commissions. In this workbook there are separate worksheets for each salesperson, ( Alan, Dan, Jim, Walter, Roseanne). Each worksheet is formatted the same with headers for date (col A), po# (col B), status (col C), customer (col D), manufacturer (col E), and sales amount (col F). Under status in column C is listed either open or paid, depending on if the sale is completed or not. At the end of each month I would like to run a macro to search for all the open listings from column C in each of the 5 worksheets begining in the range c2:c200 and then copy the entire row where an open exists, a2:F2 for example, to another worksheet called open accounts in the same workbook. I believe this is possible, just beyond my abilities. Any pointers please?