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
Bookmarks