Easy way to show 3 groupings in Excel

I have three sets of grouping on my sample file attached.  If I click 1or 2 (at top right) then either all groups expand or close up.  Is there a way to have numbers 1, 2, 3 up top and clicking on each number will expand just one of the sections?
Book1.xlsx
daisypetals313Asked:
Who is Participating?
 
nutschCommented:
You can use something like this:

If ActiveCell.EntireColumn.ShowDetail Then
   ActiveCell.EntireColumn.ShowDetail = False
Else
    ActiveCell.EntireColumn.ShowDetail = True
End If

Open in new window


Thomas
0
 
NBVCCommented:
I don't think so, but you can easily just click the + sign above the group you want to expand, then click the - sign to contract it...
0
 
nutschCommented:
Just like he said, but you could build a macro that would expand / collapse the currently selected group and code it to buttons marked 1, 2, and 3.

Thomas
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
daisypetals313Author Commented:
Does anyone know what macro code would do this?
0
 
andrew_manCommented:
Add a vba button and use the above code
0
 
daisypetals313Author Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.