+ Reply to Thread
Results 1 to 9 of 9

Create a Grouping Macro, using an Outline column to quickly group rows

  1. #1
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Cool Create a Grouping Macro, using an Outline column to quickly group rows

    Hi guys.

    I my question refers to group (Data > Outline > Group), see the photo below to see what I mean.

    Groupings.jpg

    I am dealing with many rows, Adding and deleting them throughout my project's life cycle (12 months), getting all the groups correct to display information changes and it is very time consuming to do it manually!

    My idea is to have Column A as an "Outline" with a number from 1-7, and a macro will group rows according to the numbers.

    For example, After this macro all the groups will be sorted properly. If I then pressed the little gray box "2" (top left and side), the sheet will only show rows where Column A was equal to 1 or 2.
    gray box "3" would show rows with the 1,2,3 in Column A, etc.



    Thanks guys,

    Any help would be really awesome!
    Jimmy
    Last edited by JimmyWilliams; 10-20-2017 at 03:03 AM. Reason: Trying to make the example clearer.

  2. #2
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Create a Grouping Macro, using an Outline column to quickly group rows

    *Bumping, still relevant problem*

  3. #3
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Create a Grouping Macro, using an Outline column to quickly group rows

    I have created some code that is a bit similar, but needs a few adjustments.


    Please Login or Register  to view this content.
    Any help would be appreciated.
    Jimmy

  4. #4
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Create a Grouping Macro, using an Outline column to quickly group rows

    **Still a big problem for me!

    Will continue to provide updates. when i can.

  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Create a Grouping Macro, using an Outline column to quickly group rows

    Hi JimmyWilliams,
    Could you attach a file with an example of what you want to achieve

  6. #6
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Create a Grouping Macro, using an Outline column to quickly group rows

    Project Estimate.xlsm
    Use the attachment above. Not the other one below (I don't know how to remove it).

    I am trying to make this spread sheet dynamic, so I can use it in the future again.
    My idea is to manually go down column A and substitute a number 1 to 7 and then the macros will do all the rest.
    Column A determines what rows (line items) are part of which groups.
    I have managed to make the Budget column to work, each level subtotals the lower levels. if the user has entered a value into a higher level it continues to use to use that value but turns it yellow.
    I have attached a stripped down version of the spreadsheet, keeping just the required parts (to make it neater).
    I have attached the modules that I am using.


    NoteGroupJ20171030
    NoteGroupM20171030


    I am having trouble creating a macro to automatically group everything.
    When you press the gray 1, all the level 1's should show.
    When you press the gray 2, all the level 1's and 2's should show.
    When you press the gray 3, all the level 1's and 2's and 3's should show.
    When you press the gray 4, all the level 1's and 2's and 3's and 4's should show.
    etc



    Side note:
    The WBS codes are a mess but I think I have a way of fixing them. The Sheet "Format of the WBS codes" shows the colour coding and an example of how the WBS should work.
    The WBS codes should be generated from the level column too and be dynamic, (so if you insert a new row it would have the next correct value assuming it is the same level).
    Attached Files Attached Files
    Last edited by JimmyWilliams; 10-30-2017 at 06:44 PM. Reason: updated .xlsm file

  7. #7
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Create a Grouping Macro, using an Outline column to quickly group rows

    This is time critical for me, I could really use some help!

  8. #8
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Create a Grouping Macro, using an Outline column to quickly group rows

    Hi guys,

    Did it myself, was easier then I thought.

    Please Login or Register  to view this content.
    Jimmy

  9. #9
    Forum Contributor
    Join Date
    04-02-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    403

    Re: Create a Grouping Macro, using an Outline column to quickly group rows

    Would really love it if someone had a better way of writing

    Please Login or Register  to view this content.

    Thanks
    Jimmy

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to Group Rows (outline) based on Text
    By IndieKiller in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2017, 09:48 AM
  2. Macro to Group (Outline) rows based on cell values
    By excelatnothing in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2015, 02:13 AM
  3. Automatically outline (group) rows based on date
    By jabba9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2014, 05:33 AM
  4. HELP! Macro to Outline and Group my Data
    By clairewarrensmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2014, 02:04 PM
  5. Excel Macro to Group by bold subtotal rows (multiple levels of grouping)
    By aozorap in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2013, 03:13 PM
  6. Replies: 2
    Last Post: 09-02-2011, 03:52 PM
  7. HOW TO CREATE DIFFERENT GROUP AND OUTLINE IN EXCEL
    By Viswanathan Balaji in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-25-2006, 01:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1