I would open each book and create a summary sheet/book and then at the
end of the macro print the results.

You have to open each workbook, determine if the data matches your
requirements, and then print the results (or copy the data to a summary
sheet) .


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=146983