I'm creating a model for a client that has a list of actions that they want grouped together based on their focus. I've put in identifiers to help with the grouping, but I'm having trouble illustrating it the way they want while still have it automatically compile itself. There are three levels, with each action lumped together at two higher levels (illustrated by the identifiers: the first number is the highest level, second the middle, and so on). So, here is how the list would look with only the identifiers:
1.1.1
1.1.2
1.2.1
1.2.2
2.1.1
2.1.2
2.2.1
2.2.2
The problem is that they need to be grouped together by all possible levels and illustrated that way, updating automatically. The ideal end state for the above example is this:
1.0
1.1
1.1.1
1.1.2
1.2
1.2.1
1.2.2
2.0
....
Now, the big kicker is this: I can't use any VBA or macros. The client refuses to change their security settings for fear of spreading some imaginary virus (I'm not kidding).
Where I am getting hung up is actually getting the actions to list themselves: with VBA, it'd be very easy to setup a for loop or something like that, but without it I'm stuck.
Any ideas?
Bookmarks