Get instant live expert help on I need help with group ungroup excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Sub EnableOutlining()
'Update 20140603
Dim xWs As Worksheet
Set xWs = Application.ActiveSheet
Dim xPws As String
xPws = Application.InputBox("Password:", xTitleId, "", Type:=2)
xWs.Protect Password:=xPws, Userinterfaceonly:=True
xWs.EnableOutlining = True
End Sub
This is the VBA code i am using to be able to group and ungroup things in excel while the sheet is protected. when i close and reopen the code no longer works
Solved by I. B. in 27 mins
Hi, I have a table that shows a list of groups (group a, group b etc) and displays that there are 2 people in group 'a', 5 people in group 'b', 2 people in group 'c', 6 people in group 'd' etc...
I would like to format/display the list show so it only shows the groups that have 2 or less people in each group...
I am a complete excel novice....
Thanks you!
Solved by T. Q. in 26 mins
Hi, I am just trying to group dates in my Excel pivot by weeks not days and it won't let me group them.
Solved by O. A. in 15 mins
In cells B16 and D16, with the worksheets still grouped, calculate the total number of students and total charges for the school. Ungroup the worksheets, and then save the workbook.
Solved by X. B. in 21 mins
Hi - I have two columns - one is group and the other is user which looks something like this:
Group A - User X
Group A - User Y
Group B - User Z
I need to convert this to show all groups as a column and all users under the respective group like this:
Group A GroupB
User X User Z
User Y
Solved by I. B. in 29 mins