Consolidation reporting

Hello Nik

Thank you for your question and welcome to the forum.

It depends on how complex this needs to be and also on the data you are consolidating.

You can do this manually using Data - Consolidate, if there is not too much data to pull together.

Otherwise if you are looking at getting Excel to automatically pull through lots of data from various files, and you need to be able to arrange or manipulate the data in a particular way then you would be looking at using VBA coding to achieve this.

Kind regards
Amanda