Nested grouping of rows using vba in excel
Hi all, I need help with nested grouping of rows using macros. My macro currently is able to just group at a single level and it takes a long time as I have 50,000+ rows. I would like to group 2 levels. I have attached a file with original data set, current output using my macro and expected output. Appreciate all the help I can get, thank you in advance.
Maybe this?
HTML Code:
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Re: Nested grouping of rows using vba in excel
I tried the below code but it isn't nesting the groups as expected. I also switched the blocks (Column C grouping on top and Column B grouping below) but it isn;t working right.
Please Login or Register to view this content.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. I have done it for you today.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ok, will keep that in mind. Thanks Ali
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks