G
gssitaly
With a macro.....please!
In column A of sheet STAT_L0953 have a value and the same value are present
also in column A of L0953.
In column D of sheet L0953 have a value are present also in line 2 of sheet
STAT_L0953.
Now intersec the value and summ the value refered the column O (are aumont)
put the result of the summ in eache cella basec AG. and value in line 2 of
sheet STAT_L0953...
Example:
AG. = 4500
TIPO SOSP = 146900090000
cell L3 of STAT_L0953 = 4219320,51
AG. = 4503
TIPO SOSP = 111000010000
cell H5 of STAT_L0953 = 2850,00
ecc...
here the example file:
http://www.mytempdir.com/1176302
tks
In column A of sheet STAT_L0953 have a value and the same value are present
also in column A of L0953.
In column D of sheet L0953 have a value are present also in line 2 of sheet
STAT_L0953.
Now intersec the value and summ the value refered the column O (are aumont)
put the result of the summ in eache cella basec AG. and value in line 2 of
sheet STAT_L0953...
Example:
AG. = 4500
TIPO SOSP = 146900090000
cell L3 of STAT_L0953 = 4219320,51
AG. = 4503
TIPO SOSP = 111000010000
cell H5 of STAT_L0953 = 2850,00
ecc...
here the example file:
http://www.mytempdir.com/1176302
tks