Paul:

Are you looking for;

Dept 1
Revenue
Expenses

Dept 5
Revenue
Expenses

Dept 7
Revenue
Expenses

Keep going for all departments....

Then at a future date if Dept 3 is added, you want the financial statement to automatically insert the new department to created;

Dept 1
Revenue
Expenses

Dept 3
Revenue
Expenses

Dept 5
Revenue
Expenses

Dept 7
Revenue
Expenses

It's possible but you would need to be an ultra high expert in either or both of Excel and Adagio FR.

Explaining how to make this work would take a significant effort. Accsys is always willing to take on these types of projects on behalf of other Adagio dealers. Feel free to contact me offline.