Creating a CrossTab Report using data in variant

[Dennis Bachani]

Hi,

Will appreciate if I could get some help creating a cross-tab report as
follows:

I have a variant that has the foll. data:

units Price Exp Date
100 25.00 05/07/2004
200 35.00 05/07/2004
300 15.00 05/07/2004
500 90.00 05/08/2004
600 95.00 05/09/2004
350 70.00 05/09/2004

What I need to output it as follows:

Exp Date
Price 05/07/2004 05/08/2004 05/09/2004
25.00 100
35.00 300
15.00 800
90.00 500
95.00 600
70.00 950

It adds the units as long as the dates are same. Can someone pls help me
with this. I am trying to do this in a vba macro.

Thanks a lot.

 

[ross]

Pivot Tables!!!!!!!!!!!