but frank, this is for user to process themselves.
accumulate in 1 sheet and put in another sheet. u may refer to my table below.
frank, thanks

"Frank Kabel" wrote:

Hi
though this is possible I would really try a pivot table for this:
- much simpler to use
- no macros required

--
Regards
Frank Kabel
Frankfurt, Germany

"mango" schrieb im Newsbeitrag
...
dear frank, i mean using vba.
thanks

"Frank Kabel" wrote:

Hi
have a look at 'Data - subtotals' and 'Data - pivot table'

--
Regards
Frank Kabel
Frankfurt, Germany

"mango" schrieb im Newsbeitrag
...
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