Barb,

Yes, you never said that you had a database, but I wanted to be clear in my
description, since pivot tables expect database style data tables. That's
why I asked for an example of the type of data that you had.

HTH,
Bernie
MS Excel MVP

I never said I had a database. I'll take a look and see what I can glean
from the link.