If you can easily get your output in the form of a database query that
delivers a table with columns for customer number, product number and
product count then you can make a pivot table based on this query with
customer number as row field, product number as column field and
product count as data field.

Then in the cells which display the data you can use a GETPIVOTDATA
worksheet function to extract the appropriate value from the pivot
table. Excel 2002 and later would allow a function like
=GETPIVOTDATA("Sum of Product Count",PivotSheet!A3,"Customer
Number",X2,"Product Number",A4)

Where the pivot table is at A3 on sheet PivotSheet, the customer number
you want is in X2 and the Product Number is in A4. Before Excel 2002
the function had a different set of arguments which were harder to
construct. Hope you have 2002!

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup