with this sheets is possible, with a mcaro, to summ valuie from column I of h7469 and add the total in line refred index in column a of sheet DB_agenzie....
Example:
from sheet h7469 summ the value with index EUUL only from 4500 and insert t6otal in P3 of sheet db_agenzie...
from sheet h7469 summ the value with index ECPF only from 4500 and insert t6otal in H3 of sheet db_agenzie...
Ecc...
Use this for all index in column A of asheet h7469 end index A of sheet db_agenzie
in effect a pivot but not pivot
sorry for dimension of file
http://www.mytempdir.com/1087803
Bookmarks