>>Hi,
>>
>>An Excel workbook contain historical data. Each row contains year, product name, and sales for one invoice
>>
>>I want to create a separate sheet with this format, where xxxx is the sum of sales in all invoices for given product and year.
>>
>>

>>            2009     2010    2011
>>Product1    xxxx     xxxx    xxxx
>>Product2    xxxx     xxxx    xxxx
>>Product3    xxxx     xxxx    xxxx
>>

>>
>>Does anyone know how to do this right in the Excel workbook?
>>
>>TIA,
>>
>>Alex
>
>Use PivotTable wizard in Excel
>
>Good Luck

Thank you! A whole new world. Now I have to learn it.

Alex