| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to do the sum at the last when ever type chages
So then lets go back to my post of yesterday... Why not use pivot tables?
Click refresh after re-populating the data and the totals will change dynamically. -- HTH... Jim Thomlinson "ramse" wrote: Because I'm populating this totals along with data dynamically. Dave Peterson Wrote: Why not just use Data|Subtotals? ramse wrote: Hi, I'm cracking my head to do this task . I'm written some code its not working fine. Pls help me out. The macro have to sum the column data at last row whenever the type chages. type hr1 hr2 ------ -- --- S7 10 20 S7 30 30 S14 40 30 S14 20 50 S7 40 50 S14 60 80. Your help is greatly appreciated. Thanks, Ram. -- ramse ------------------------------------------------------------------------ ramse's Profile: http://www.excelforum.com/member.php...o&userid=31544 View this thread: http://www.excelforum.com/showthread...hreadid=512787 -- Dave Peterson -- ramse ------------------------------------------------------------------------ ramse's Profile: http://www.excelforum.com/member.php...o&userid=31544 View this thread: http://www.excelforum.com/showthread...hreadid=512787 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop type formula - no Macro | Excel Discussion (Misc queries) | |||
| how do i use code39 bar codes that update as a cells value chages | Excel Worksheet Functions | |||
| Macro error type mismatch | Excel Discussion (Misc queries) | |||
| Addition type macro | Excel Discussion (Misc queries) | |||
| "AutoPrint" type macro requires tweaking | Excel Discussion (Misc queries) | |||
![Jim Thomlinson[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
