|
Macro to do the sum at the last when ever type chages
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 |
Macro to do the sum at the last when ever type chages
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 |
Macro to do the sum at the last when ever type chages
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 |
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 |
| All times are GMT +1. The time now is 05:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com