philfer
04-10-2008, 05:20 AM
Hello,
I am working on a workbook at work (!!) which basically takes a huge amount of data and then on subsequent sheet summarises it by :-
1) Person
2) All the people in a department
3) For the organisation as a whole
This includes current years figures with previous years as a comparison and a contrast to the budget figures
The workbook is growing out of control especially with all the formulae in it
I wonder if Excel has any built in analysis tools. I know there is Data Consolidate but I almost want to do the opposite of this.
Has anyone ever done anything like this in the past and have any advice for me
Thanks
I am working on a workbook at work (!!) which basically takes a huge amount of data and then on subsequent sheet summarises it by :-
1) Person
2) All the people in a department
3) For the organisation as a whole
This includes current years figures with previous years as a comparison and a contrast to the budget figures
The workbook is growing out of control especially with all the formulae in it
I wonder if Excel has any built in analysis tools. I know there is Data Consolidate but I almost want to do the opposite of this.
Has anyone ever done anything like this in the past and have any advice for me
Thanks