LinkBack URL
About LinkBacks
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.
How to get all groups by rows Excel and for each group get it row range, set subtotals
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 clickingbelow 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
Originally Posted by XeRo Solus
Thank you, for your reply.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?
I have data in this format
Data1 and Data2 manual imput
And I need to write macros, which set subtotals by groups, but I can't understand how to get each group range in macros.
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)
Posting Permissions
Register To Reply
Bookmarks