View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sal21 sal21 is offline
external usenet poster
 
Posts: 18
Default summ aumont with interesection with 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