summ aumont with interesec two index....

[sal21]

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...

[lucas]

Hi Sal,
I can follow you down to this part where I get lost.

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...

Could you please clarify what your trying to do as I don't understand? Maybe upload your workbook again with some arrows and comments just to make it easier to understand.

[Bob Phillips]

I think he wants to fill the grid from the data tables on the other sheet, dynamically. I offered a formula on MrExcel, but he wants VBA.

[sal21]

Hi Sal,
I can follow you down to this part where I get lost.

Could you please clarify what your trying to do as I don't understand? Maybe upload your workbook again with some arrows and comments just to make it easier to understand.

hi lucas, xld is correct fill the sheet STAT_L0953 similar data grid...
in effect i know the way to fill the sheet STAT_L0953 with formula (see my new attach) but i want to have the same result with a macro...

tks or yours jobs and sorry for my terrible english.

[lucas]

Hi Sal,
Don't worry about the english....you do a lot better than I would with your language I'm sure...

Could you give a link to the post at MrExcel as a courtesy to those trying to help you with this?

[sal21]

Hi Sal,
Don't worry about the english....you do a lot better than I would with your language I'm sure...

Could you give a link to the post at MrExcel as a courtesy to those trying to help you with this?
... yes lucas

[Bob Phillips]

MrExcel (http://www.mrexcel.com/board2/viewtopic.php?t=253182&sid=695f57d6fc6879be8f0f1810ddd0d2e6) and Experts Exchange (http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_22086015.html) (with an accepted answer!) and Usenet #1 (http://tinyurl.com/3ayh4d) and #2 (http://tinyurl.com/3d4l7x).