I appreciate the input. However, this was a small sampling of data. The
actual data is thousands of lines long with over 20 different summary sheets
for over 100 different worksheets. I have been cutting and pasting thus far
and it takes me at least a weeks worth of work to complete each month. An
automated solution will save tens of thousands of dollars over the course of
a year. Thank you again for the suggestion.
With respect,
Geo

"mrice" wrote:


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