marco help
Keep getting an error message with i try to write a marco to caculate the subtotal of a items. say i am trying to total the number of sales a rep has for a product. please see example below and help. ID Product Item Sales p1 beh 1745 20 p1 hbe 1742 5 p1 bed 125 10 p1 hbe 172 15 p2 hbe 1742 52 and so on with several defferent ID and products.......any help you could give would be helpful. -- mr1104839 ------------------------------------------------------------------------ mr1104839's Profile: http://www.excelforum.com/member.php...o&userid=37661 View this thread: http://www.excelforum.com/showthread...hreadid=572716 |
marco help
Did you turn on the macro recorder and do it manually?
Also, you would need to sort by ID and then Product before you do it to get the correct subtotals. -- Regards, Tom Ogilvy "mr1104839" wrote: Keep getting an error message with i try to write a marco to caculate the subtotal of a items. say i am trying to total the number of sales a rep has for a product. please see example below and help. ID Product Item Sales p1 beh 1745 20 p1 hbe 1742 5 p1 bed 125 10 p1 hbe 172 15 p2 hbe 1742 52 and so on with several defferent ID and products.......any help you could give would be helpful. -- mr1104839 ------------------------------------------------------------------------ mr1104839's Profile: http://www.excelforum.com/member.php...o&userid=37661 View this thread: http://www.excelforum.com/showthread...hreadid=572716 |
marco help
Are you trying to insert Subtotals (Data - Subtotal) or are you trying to
write a macro to look through your data and determine some subtotals? To insert subtotals turn on the macro recorder and just have at it. To determine the subtotals via code I mighrt suggest using a sumproduct formula instead... Here is a link... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "mr1104839" wrote: Keep getting an error message with i try to write a marco to caculate the subtotal of a items. say i am trying to total the number of sales a rep has for a product. please see example below and help. ID Product Item Sales p1 beh 1745 20 p1 hbe 1742 5 p1 bed 125 10 p1 hbe 172 15 p2 hbe 1742 52 and so on with several defferent ID and products.......any help you could give would be helpful. -- mr1104839 ------------------------------------------------------------------------ mr1104839's Profile: http://www.excelforum.com/member.php...o&userid=37661 View this thread: http://www.excelforum.com/showthread...hreadid=572716 |
All times are GMT +1. The time now is 02:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com