You're welcome, Roddd !
Glad to see you've got a solution from Domenic ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Roddd" wrote in message
...
Thanks for the help Max.

Unfortunately (and I should have mentioned this in the original post),
Sheet
B contains roughly 10,000 Cust IDs and more than 1,000 product IDs, which
is
beyond the columnar limit of an Excel pivot table.

Your example was very helpful.....it just does not solve my problem in
this
case.

Thanks,
Rod