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
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