Download the Practice Excel File of main Article "Data Consolidation in Microsoft Excel"
Regards,
KumarMukesh
Attached File : 304961 1396064 data consolidation.xls downloaded: 841 times
Menu
Data consolidation in excel
Attached File : 304961 1396064 data consolidation.xls downloaded: 841 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 :
- Sale of shares in indian company by a non resident
- Difference in TIS
- GSTR-9C Upload Status Error Occured
- “Income Tax Implications of Company-Related
- Advice needed: Hypothetical case of non-filing of
- Demand Raised for Cess Amount Despite Section 89 R
- WRONG BILL NO FILED IN GST R1
- Addtional trade name for my another firm
- Commission / Agency Business without books: REAL E
- Difference between AIS and 26AS data.
Related Topics :
CAclubindia
