Consolidating data in excel 2007

Hi Jasmina

Thanks for your question

They are 2 rather different things

Data consolidation involves aggregating data held in the same column and row format across different worksheets. For example you might have a table showing sales per employee per region, and have the same table in different sheets for different months. A consolidation would build a "master table", showing total sales per sales person per region for the whole year.

A pivot table however, takes data stored in the form of a list and provides a multidimensional analysis of it. This only works with excel databases and lists and allow a cross tab analysis of the different fields

Regards

Stephen