I have a workbook to track sales and commissions. In this workboo
there are separate worksheets for each salesperson, ( Alan, Dan, Jim
Walter, Roseanne). Each worksheet is formatted the same with header
for date (col A), po# (col B), status (col C), customer (col D)
manufacturer (col E), and sales amount (col F). Under status in colum
C is listed either open or paid, depending on if the sale is complete
or not. At the end of each month I would like to run a macro to searc
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 a
open exists, a2:F2 for example, to another worksheet called ope
accounts in the same workbook. I believe this is possible, just beyon
my abilities. Any pointers please

--
adelphu
-----------------------------------------------------------------------
adelphus's Profile: http://www.excelforum.com/member.php...fo&userid=3582
View this thread: http://www.excelforum.com/showthread.php?threadid=55598