ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   summ aumont with interesection with two index.... (https://www.excelbanter.com/excel-discussion-misc-queries/127013-summ-aumont-interesection-two-index.html)

sal21

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


All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com