Thread: Reporting tool

hi nilem,
thanks for your help, it looks amazing.
principal is that Montnt déb is positive amount and Montnt créd. is negative amount, if you could also assign them some fonctionality, it would be perfect.

nilem, 1 remark to your excellent work.
I have new confirmation from my colleague - in sheet Analyseur - these values in column "V" which are not numbers (p.ex 345- )
, should be deleted, so we only operate with numbers, so no converting to numbers, is it possible to add this fonction into your work?

thanks in advance and sorry for late reply...

See attachment.
If the fractional part delimiter of your operating system is a point (.), then you will not need a green 'helper arrow'.

great !
thanks for your kind help, it works fine !

Hello all,
it works great, but I need small modification of this file.
Problem is that we have sometimes more rows for some employees in sheet Analyseur. Is it possible to modify the file to give us exact results?

if something is not clear , please ask me.

Thanks in advance for your kind help.

tomsheek

Hello, Tomsheek. I have not found depending on the number of rows in 'Analyseur' worksheet. Can you attach a sample file with your problem?