is there any way i can subtotal rows in Excel report by certain
Criteria. for example this is the report i have
Company code Gl code Total paid amt
1002 10210 220 USD
1002 23454 10 USD
1002 23567 1000 USD
SubTotal 1010 USD
1005 32222 10 USD
1005 23467 12 USD
Sub Total 12 USD
Now the above report has subtotals for paid amt at the end of every
Company code. But as you can see the subtotal is calculated for only
GL codes starting with digit 2.
Is there any way to set criteria like that for a subtotal using a
formula bar. i donot see any options like that in subtotal tool bar in
excel 2007. Is there any macro? how to add that macro ? pls help by
step by step instructions. Thanks
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 5,200 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
