Consolidating data

[zahra]

Hello
I am trying to consolidate data from various Excel sheets/files. I need to sum up all the figures from these sheets into one sheet. To clarify, i have customer's names down my column A and products across my row 1 for all my sheets (each eat represents a branch of the bank), each customer can be in some sheets but not others. What is the best way to make excel read the data across these sheets and give me the final sum for each customer and its corresponding product type? I am thinking sumproduct.. but is there any other way?

 

[NARAYANK991]

Hi ,

You can use the Pivot Table wizard to do the consolidation.

See the attached file , and go through this link :

http://www.contextures.com/xlPivot08.html

Narayan