Excel is the tool I am using. I need to group/filter project activities so to show summary at project level, and details for anyone project. I have tried Excel functions but without any luck. Need to accomplish this without VBA if possible. Any thoughts would be helpful. The attached spreadsheet shows what I am trying to do. Let me know if you have questions. Any thoughts would be helpful. Thanks. - Tom EE.xlsx
I have applied the grouping manually but there are ways of doing it automatically if the real data set is much bigger.
Use the buttons in the left hand margin to collapse/expand individual groups or the number buttons at the top of the left hand margin to collapse/expand all groups to a specific level.