Extrq

[Melko]

I am using M$ Excel 2000.

I need to make a completly automated sheet that take datas from a matrix so like:

Description    DATE       Money
A goood one    01/01/2003 500 €
A bad one      01/01/2003  -5 €
An other day   05/06/2003  22 €
ect            ect        ect

making a briefing where all the same date have summed the monay with no black lines and no user interaction needed.

I thought about make a sheet with all possible dates + a conditional sum, finally use a filter to hide "0 money" row. But the filter does not recalculate it self automatically.

Any clues?

 

[ardilesd]

Have you tried using a Pivot Table, with Date in the rows and the money as data (As Sum).
This would give the report as you request
Regards

 

[Melko]

Unluckly not even the pivot table automatically recalculates, you have to click on the "!" icon, I'd have to find a way to do this without user iteraction.

My chief has very clear about this...

Is there a way to start a macro everytime the sheet is recalculated?

 

[melone]

Make sure your pivot table is on a different worksheet (tab) than your data. Then tell the pivot table (via VBA) to recalc everytime you click on the sheet. (VERY trivial, just play around with it and you should be able to figure it out)

 

[Melko]

Thanks Melone and everyone, it worked.

A small advice to everyone do not know VB, just make a macro and copy the line from there...