Thanks or ur help PA.
As u've written, i'm looking for 3 different msgbox popping one after the
other, on for each DES_CC. Each msgbox would contain the name of the DES_CC
and all the
DELTAs.

here the output I want:
the first msgbox:

"the following employes of EXP A office got these discrepancies:"
LIL 2

the second msgbox:

"the following employes of EXP B office got these discrepancies:"
TOP -1
PAPERIN -8
GEP -1

the third:

"the following employes of EXP c office got these discrepancies:"
TOr -1

Thank you for your precious help.



--
BBB


"PA" wrote:

I'm not sure that I understand what you want. Do you want (based on your
sample sheet) to have 3 different msgbox popping one after the other, on for
each DES_CC. Each msgbox would contain the name of the DES_CC and all the
DELTAs.

or

A formula that would return all the deltas for one DES_CC on the same row?

And finaly, if you can't make a script because you don't know how, give me
the exact output you want and i'll write you one (if it's not a 3 days long
project;))

PA

"AND" wrote:

unfortunately, I can't make a VBA scrip like this; i'm not so cute :(
Can u give me some infos else or a formula based about my example please?

"AND" wrote:

HELLO,
In SHEET3 I have this table beginning from B column:
DES_CC COD NAME TIME1 TIME2 TIME3 DELTA
Exp A 10025 PIP 12,00 12,10 12,00 0
Exp A 10026 LIL 12,00 13,74 14,00 2
Exp B 10027 TOP 10,00 9,03 9,00 -1
Exp B 10028 PAPERIN 15,00 7,49 7,00 -8
Exp B 10029 GEP 10,00 9,36 9,00 -1
Exp B 10030 Z 5,00 4,71 5,00 0
Exp B 10031 MIN 10,00 10,10 10,00 0
Exp C 10032 PLUT 5,00 4,50 5,00 0
Exp C 10033 ZOR 5,00 4,51 5,00 0
Exp C 10034 TOR 4,00 2,71 3,00 -1
Exp C 10035 ORES 5,00 4,51 5,00 0