• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to summarize the data in dynamic ranges across sheets?

rkspeaks

Member
Hello,


I have my data in 12 sheets named by the month names and a Summary sheet.

I have to summarize the data.


The columns in all the sheets are Product, Qty for 4 regions, Sales for 4 regions, Commission for 4 regions.


Each month Sales varies. That's the problem for me to use consolidate feature.


For detailed information please download the sample file below.


Sorry here is the updated link.


http://speedy.sh/cCPxJ/JCB.xlsx


Regards

RK
 
Hi rkspeaks,


Please use the last sheet to consolidate data:


http://dl.dropbox.com/u/60644346/Consolidate%20Unsized%20Data.xlsx


Regards,
 
RK


You can also use SQL within Excel to consolidate data from various worksheets


Refer:

http://chandoo.org/wp/2012/04/09/consolidate-data-from-different-excel-files-vba/

http://chandoo.org/forums/topic/how-do-i-consolidate-several-tables-in-one-long-table
 
Hey ,

Thanks everybody who got their hands dirty for me.


I will try these options and come back to you. Sorry for the late reply.


regards

RK
 
Back
Top