As pecoflyer said in post #3, it would be really helpful if you could post a workbook with some representative data. We don't need anything sensitive, just something that lets us see the kind of structure & data you're working with - it doesn't even need to be separate workbooks, since a solution that works with separate worksheets will generally work equally well for separate workbooks.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]