Extrq
Extrq
(OP)
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?
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?





RE: Extrq
This would give the report as you request
Regards
RE: Extrq
My chief has very clear about this... :(
Is there a way to start a macro everytime the sheet is recalculated?
RE: Extrq
RE: Extrq
A small advice to everyone do not know VB, just make a macro and copy the line from there... ;)