Consolidate financial data from subsidiaries

[Hassanhadid]

Hi guys,

i am looking for macro code to enable me to copy company data from different excel worksheet to main consolidation file.(to avoid external links)

This process is monthly and i need the code to copy and past the data to the main worksheet.

Attached is a diagram to show how i believe macro should work.

**Challenge:

• Every subsidiary file will have three sheets( P&L, BS,CF)
• Every sheet has 4 column of data to be transferred ( YTD actual, YTD budget, Budget & latest forecast)
• The posting from subsidiary sheets to main sheet will be in different reference cell

 

[vletm]

Hassanhadid
The Challenge is that You uploaded one PDF and it's without data.