The simplest way to do this is with autofilters, copying the rows for
each type to the summary sheet. As you are only doing this once a month
this shouldn't take too much time. You could go for an automated
solution with macros but this is maybe over the top.
--
mrice
Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile:
http://www.excelforum.com/member.php...o&userid=10931
View this thread:
http://www.excelforum.com/showthread...hreadid=548328