Hello.
I have Excel file with many groups by rows, but without any subtotals.
1) How to add subtotals to the existing groups?
2) How to get all groups by rows on the sheet?
3) How to get a range of rows in the groups?
Can't record this in macros.
Hello.
I have Excel file with many groups by rows, but without any subtotals.
1) How to add subtotals to the existing groups?
2) How to get all groups by rows on the sheet?
3) How to get a range of rows in the groups?
Can't record this in macros.
Sounds like maybe a pivot table. Can you attach an example?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clicking below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Hi and welcome to the forum
do you mean you do not want to use a macro, or that you do not know how to make a macro for this?Can't record this in macros.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Last edited by its_dens; 07-11-2013 at 03:51 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks