group column

nbargaje

Member
Also i found vba for this but unable to use as its showing some errors. since i am not familiar with vb code much. may you can try and compile.

Sub Group_Sheets()
Dim ws As Worksheet

For Each ws In Worksheets
ws.Select
Columns("D:F").Group
Columns("H").Group
Columns("O:Q").Group
Columns("S").Group
Columns("Z:AB").Group
Columns("AD").Group
Next ws

End Sub
 

Manikanta

Member
Also i found vba for this but unable to use as its showing some errors. since i am not familiar with vb code much. may you can try and compile.

Sub Group_Sheets()
Dim ws As Worksheet

For Each ws In Worksheets
ws.Select
Columns("D:F").Group
Columns("H").Group
Columns("O:Q").Group
Columns("S").Group
Columns("Z:AB").Group
Columns("AD").Group
Next ws

End Sub

Hi @nbargaje
As i to not having hands on with VB,
I'll suggest u long process,
First make ur excel in a collection, After that use Filter collection, then combine which collection u want to group.
 
Top