Seeking to replace formulas with copy/paste code

[auto.pilot]

Using XL 2010 my worksheet contains a rather large data-set, in excess of 60,000 rows. Each of the Customer Names appears only one time for each Year shown.
Sample:

Excel Workbook
	B	C	D	E
1	The original data-set has nearly 60,000 entries
2	Customer Name	State	Date	Amount Purchased
3	Buyer1	OH	12/31/2008	70
4	Buyer2	CA	12/31/2008	22
5	Buyer3	FL	12/31/2008	13
6	Buyer1	OH	12/31/2009	68
7	Buyer2	CA	12/31/2009	29
8	Buyer3	FL	12/31/2009	18
9	Buyer1	OH	12/31/2010	65
10	Buyer2	CA	12/31/2010	14
11	Buyer3	FL	12/31/2010	37
Sheet2

On a separate worksheet, I use SUMPRODUCT formulas to populate a table. This process is very slow, given the file size. I am wondering if there is a code substitute which would populate this table. I am familiar with populating a single column usin code, but this multi-column output has me stumped.

Sample:

Excel Workbook
	B	C	D	E	F
1	Historical Purchases		The original worksheet has over 100 Customer Names
2	Customer Name	State	12/31/2008	12/31/2009	12/31/2010
3	Buyer1	OH	=SUMPRODUCT(--(CustName=B3),--(EndDate=C$2),--(State=$C3),AmountPurchased)
4	Buyer2	CA
5	Buyer3	FL
6
7	Currently using formula shown, which is slow. Is there a code substitute, which would loop through the data-set and populate this table?
8
9
10
Sheet1

 

[AlphaFrog]

I made this using the Pivot Table feature (no formulas)...

<br /><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">2</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Sum of Amount Purchased</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Date</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Customer Name</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">State</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12/31/2008</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">12/31/2009</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;;">12/31/2010</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Grand Total</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Buyer1</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">OH</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">70</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">68</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;;">65</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">203</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Buyer2</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">CA</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">22</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">29</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;;">14</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">65</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Buyer3</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">FL</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;">18</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;;">37</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">68</td></tr></tbody></table><br /><br />

If you do a web search for something like Excel 2010 Pivot Table tutorial, you will find several step-by-step guides and videos.