Hey everybody,

I have a workbook overview.xls that adds up values from other workbooks.

It would be great for me if the formula evaluation or a similar tool gave output that was a bit nicer and functional to look at, example:

In my workbook overview.xls I have a cell that has the number 100 in it, and I know it is the sum of a number of cells from other workbooks.
I would like to be able to see, how these '100' are divived among the workbooks in a nice and easy way. For instance 50 maybe from gc.xls and then 25 each from dk.xls and it.xls.

The formula evaluation takes me halfway, because it can show me the values step by step, but it is not really a very neat tool

Thanks,

Lars