group columns

Hi all, I have a quick question about performing "group by" in excel. I currently have to 2 columns named, "name"' and "number" as shown below. Name Number Balance 2000 Balance 300 Balance 200 Sales Deduction 20 Sales Deduction 30 ROI 20 ROI 10 Balance 29 Sales Deduction 1000 ROI 90 Sales...

I need help with VBA to group columns on the basis of criteria in Row 13. If row 13 contains the word "Result" then columns will be grouped. The Columns shows the Category first & then all the sub categories and I want to show the categories only.

Hi Everyone, I am very limited in my Macro/VBA skills and have been trying to shorten a process my team and I do multiple times a month. Every reporting period we have to go through our reports and group/ungroup columns based on what period it is. For example, we may have the columns set up as...

Hi guys, I need some help. I have a couple of groups of columns grouped, i.e. separate groupings of 5 columns. Certain cells within various groups have hyperlinks that are linked to certain cells that are within other groups. If a group is closed (minimized with the '+' sign displayed) and I...

Hi, I'm running the below code which protects all worksheets in a document, I want to allow the user to be able to click and use the grouping buttons also [+/-], what am I doing wrong in the below. Application.ScreenUpdating = False For Each wSheet In Worksheets wSheet.Protect...

I would like to have the ability, even through a macro, to group multiple columns at once that are not next to each other. Any suggestions?