Sometimes you have to threaten to give the client what they asked for
before they see it isn't what they want <g.

--

"Tom Ogilvy" wrote in message ...
That should be less of a pain to create and upkeep than pivot tables. <g

--
Regards,
Tom Ogilvy


"onedaywhen" wrote in message
om...

You can query a (closed) workbook using SQL via the MS OLEDB provdider
for Jet, therefore you *can* use a GROUP BY clause on Excel data in
exactly the same way you'd use it in MS Access.