how to accumulate value and put in other sheet
 

Dear all, how to accumulate the value in table 1 and when next change
value or empty record recalculate and put in table 2 in different
sheet.
How to do in vba?
Thanks


Table 1
Item value
2110 50
2110 40
2110 10
Empty record in between
2330 94
Empty record in between
2450 120

Table 2
Item value
2110 100
2330 94
2450 120

how to accumulate value and put in other sheet
 

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"tango" schrieb im Newsbeitrag
om...
Dear all, how to accumulate the value in table 1 and when next change
value or empty record recalculate and put in table 2 in different
sheet.
How to do in vba?
Thanks


Table 1
Item value
2110 50
2110 40
2110 10
Empty record in between
2330 94
Empty record in between
2450 120

Table 2
Item value
2110 100
2330 94
2450 120