[RESOLVED] 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...

Not quite sure exactly what you want, but can't you do it with a pivot table?
Or are you filling via look ups to the predefined stats sheet?

Hi

Is this what you want?

Click on the 'Press' Command button on sheet STAT_L0953 to execute code.
Also check out the function used in the module to get the column name for use in the command button click event.

I have commented the code so you shouldn't have a problem understanding them.

Hope this helps...

[Edit 25/03/2007] : Since the post is resolved.. deleting the attachment as my total attachements have crossed the allowed limit

Quote:

---

Originally Posted by koolsid

Hi

Is this what you want?

Click on the 'Press' Command button on sheet STAT_L0953 to execute code.
Also check out the function used in the module to get the column name for use in the command button click event.

I have commented the code so you shouldn't have a problem understanding them.

Hope this helps...

---

Hi koolsid, Is perfect!!!!!!!!!!!!!!!!
But how to undertsand my Italian/English/Napolitain????
Are you a Wizard?
Tks! pizza for you!, Sure. And tks for comment in code in this mode i can go to to the Univirsity of VB;-) :wave: :bigyello: :)
Sal.