I want to create a sales report summary for each year by division. Below is the data. I would like these totals in a separate worksheet
[TABLE="width: 645"]
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 6"]Gross Sales Projections by Division / Department[/TD]
[/TR]
[TR]
[TD]Division[/TD]
[TD]Department[/TD]
[TD]2007[/TD]
[TD]2008[/TD]
[TD]2009[/TD]
[TD]3 Year Total[/TD]
[/TR]
[TR]
[TD]Electronics[/TD]
[TD]PDA[/TD]
[TD="align: right"]$2,100,000[/TD]
[TD="align: right"]$2,750,000[/TD]
[TD="align: right"]$3,750,000[/TD]
[TD="align: right"]$8,600,000[/TD]
[/TR]
[TR]
[TD]Electronics[/TD]
[TD]Video [/TD]
[TD="align: right"]$1,750,000[/TD]
[TD="align: right"]$2,500,000[/TD]
[TD="align: right"]$3,250,000[/TD]
[TD="align: right"]$7,500,000[/TD]
[/TR]
[TR]
[TD]Computers[/TD]
[TD]Laptop[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$2,100,000[/TD]
[TD="align: right"]$2,850,000[/TD]
[TD="align: right"]$6,450,000[/TD]
[/TR]
[TR]
[TD]Electronics[/TD]
[TD]Home Audio[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$1,750,000[/TD]
[TD="align: right"]$2,250,000[/TD]
[TD="align: right"]$5,500,000[/TD]
[/TR]
[TR]
[TD]Appliances[/TD]
[TD]*******[/TD]
[TD="align: right"]$1,450,000[/TD]
[TD="align: right"]$1,880,000[/TD]
[TD="align: right"]$2,005,000[/TD]
[TD="align: right"]$5,335,000[/TD]
[/TR]
[TR]
[TD]Computers[/TD]
[TD]Desktop[/TD]
[TD="align: right"]$1,750,000[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$4,750,000[/TD]
[/TR]
[TR]
[TD]Furniture[/TD]
[TD]Family Room[/TD]
[TD="align: right"]$1,230,000[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$1,700,000[/TD]
[TD="align: right"]$4,430,000[/TD]
[/TR]
[TR]
[TD]Computers[/TD]
[TD]Video Game[/TD]
[TD="align: right"]$1,230,000[/TD]
[TD="align: right"]$1,260,000[/TD]
[TD="align: right"]$1,300,000[/TD]
[TD="align: right"]$3,790,000[/TD]
[/TR]
[TR]
[TD]Computers[/TD]
[TD]Accessories[/TD]
[TD="align: right"]$750,000[/TD]
[TD="align: right"]$900,000[/TD]
[TD="align: right"]$1,100,000[/TD]
[TD="align: right"]$2,750,000[/TD]
[/TR]
[TR]
[TD]Appliances[/TD]
[TD]Laundry[/TD]
[TD="align: right"]$650,000[/TD]
[TD="align: right"]$700,000[/TD]
[TD="align: right"]$700,000[/TD]
[TD="align: right"]$2,050,000[/TD]
[/TR]
[TR]
[TD]Furniture[/TD]
[TD]Office[/TD]
[TD="align: right"]$250,000[/TD]
[TD="align: right"]$300,000[/TD]
[TD="align: right"]$300,000[/TD]
[TD="align: right"]$850,000[/TD]
[/TR]
[TR]
[TD]Furniture[/TD]
[TD]Bedroom[/TD]
[TD="align: right"]$125,000[/TD]
[TD="align: right"]$200,000[/TD]
[TD="align: right"]$225,000[/TD]
[TD="align: right"]$550,000[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 645"]
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 6"]Gross Sales Projections by Division / Department[/TD]
[/TR]
[TR]
[TD]Division[/TD]
[TD]Department[/TD]
[TD]2007[/TD]
[TD]2008[/TD]
[TD]2009[/TD]
[TD]3 Year Total[/TD]
[/TR]
[TR]
[TD]Electronics[/TD]
[TD]PDA[/TD]
[TD="align: right"]$2,100,000[/TD]
[TD="align: right"]$2,750,000[/TD]
[TD="align: right"]$3,750,000[/TD]
[TD="align: right"]$8,600,000[/TD]
[/TR]
[TR]
[TD]Electronics[/TD]
[TD]Video [/TD]
[TD="align: right"]$1,750,000[/TD]
[TD="align: right"]$2,500,000[/TD]
[TD="align: right"]$3,250,000[/TD]
[TD="align: right"]$7,500,000[/TD]
[/TR]
[TR]
[TD]Computers[/TD]
[TD]Laptop[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$2,100,000[/TD]
[TD="align: right"]$2,850,000[/TD]
[TD="align: right"]$6,450,000[/TD]
[/TR]
[TR]
[TD]Electronics[/TD]
[TD]Home Audio[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$1,750,000[/TD]
[TD="align: right"]$2,250,000[/TD]
[TD="align: right"]$5,500,000[/TD]
[/TR]
[TR]
[TD]Appliances[/TD]
[TD]*******[/TD]
[TD="align: right"]$1,450,000[/TD]
[TD="align: right"]$1,880,000[/TD]
[TD="align: right"]$2,005,000[/TD]
[TD="align: right"]$5,335,000[/TD]
[/TR]
[TR]
[TD]Computers[/TD]
[TD]Desktop[/TD]
[TD="align: right"]$1,750,000[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$4,750,000[/TD]
[/TR]
[TR]
[TD]Furniture[/TD]
[TD]Family Room[/TD]
[TD="align: right"]$1,230,000[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$1,700,000[/TD]
[TD="align: right"]$4,430,000[/TD]
[/TR]
[TR]
[TD]Computers[/TD]
[TD]Video Game[/TD]
[TD="align: right"]$1,230,000[/TD]
[TD="align: right"]$1,260,000[/TD]
[TD="align: right"]$1,300,000[/TD]
[TD="align: right"]$3,790,000[/TD]
[/TR]
[TR]
[TD]Computers[/TD]
[TD]Accessories[/TD]
[TD="align: right"]$750,000[/TD]
[TD="align: right"]$900,000[/TD]
[TD="align: right"]$1,100,000[/TD]
[TD="align: right"]$2,750,000[/TD]
[/TR]
[TR]
[TD]Appliances[/TD]
[TD]Laundry[/TD]
[TD="align: right"]$650,000[/TD]
[TD="align: right"]$700,000[/TD]
[TD="align: right"]$700,000[/TD]
[TD="align: right"]$2,050,000[/TD]
[/TR]
[TR]
[TD]Furniture[/TD]
[TD]Office[/TD]
[TD="align: right"]$250,000[/TD]
[TD="align: right"]$300,000[/TD]
[TD="align: right"]$300,000[/TD]
[TD="align: right"]$850,000[/TD]
[/TR]
[TR]
[TD]Furniture[/TD]
[TD]Bedroom[/TD]
[TD="align: right"]$125,000[/TD]
[TD="align: right"]$200,000[/TD]
[TD="align: right"]$225,000[/TD]
[TD="align: right"]$550,000[/TD]
[/TR]
</tbody>[/TABLE]