View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gssitaly gssitaly is offline
external usenet poster
 
Posts: 3
Default summ aumont with interesec two index....

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200701/1