Download the Practice Excel File of main Article "Data Consolidation in Microsoft Excel"
Regards,
KumarMukesh
Attached File : 304961 1396064 data consolidation.xls downloaded: 823 times
Menu
Data consolidation in excel
Attached File : 304961 1396064 data consolidation.xls downloaded: 823 times
Replies (4)
Thanks Mukesh .I tried this ,but if i want to add foreign plant details into consolidated file,then what will be the formula ?
=SUM(Eastern :foreign plant!C4),I tried this but it doesn't work
Dear Mansha,
There is no need to change original formula you need to just ensure that foreign plant is situated in between Easrtern to Northern sheets.
For more understanding kindly go though with my article on this function.
Dear Sir,
Very nice :)
Recent Topics :
Related Topics :
CAclubindia
