Hi
I agree with Myrna
pivot tables are really the way to go. They are even for novice users quite
simple, provide drill-down features, etc.
All macro solutions would either requi
- manually click a button / an icon to start the macro
- an event procedure that may even disturb a user and could be getting
difficult if you change data.
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
If you really want to use a macro solution maybe someone else will provide
you with the code :-)
So I would really suggest to do the following:
- remove the blank rows in between (no real need for them - they just make
formulas and everythzing else more complicated)
- setup a pivot table (I've provided some links to get started with them)
- setup 1 or more nice pre-formated pivot tables and your users will
probably be able to use them without any problems
"mango" wrote:
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