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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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