Hi. Looking for some help on grouping non-consecutive rows in a spreadsheet. I have a filing structure list that I want to group by levels so the user can collapse and expand the list based on their need and have been unsuccessful so far because I am trying to group non-adjacent rows together. I am sure there is a logical way to do this, but haven't been able to figure it out so far. I am trying to upload the file to this post but it is taking a very long time. Basically, there are 3 columns and several hundred rows of data. In the 1st column, I have the names of the 4 levels I want the data grouped by, the 2nd contains the filing code and the 3rd is the name of the file (not that this really matters!). I want the user to be able to click the 1st level button in the group and see every row that contains the highest level of the filing structure called "Document Type" only; if they click the 2nd level in the group, they will see the "Document Type" and 2nd level data called "Topic" and continue through level 4. Within each group, they can collapse/ expand rows as needed. Every time I try to do auto outline across non-consecutive rows, I get the error message "The command you chose cannot be performed with multiple selections. Select a single range and click the command again". I am sure I am missing some logic in how I am doing this. Any help would be appreciated. Thank you.
Bookmarks