Automatically group rows based on cell value

[Jd2023]

Hi all,

I would also like to automatically group rows together when a name is populated in column A?

Is that possible? Names would be, Sarah, Jane, Julie.

Thank you.

Kind Regards
Jasmine

 

[Kevin_Li]

If you want to group automatically, you can add a column of group name, and then sort by group as keyword.

 

[Jd2023]

Yes but I would like this to happen automatically, as oppose to everytime I enter a name on a new row I have to sort.

Is this possible? That the row would automatically jump next to the rows with the same name enterered in collumn A?

 

[Kevin_Li]

That requires VBA, which is not recommended as it will make the operation very strange

 

[vladimiratanasiu]

Use this code in Private Sub Worksheet, adjusting its content references as you need. When you insert new names in column A, they should sort automatically in alphabetical order.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
    Range("A2").Sort Key1:=Range("A3"), _
      Order1:=xlAscending, Header:=xlYes, _
      OrderCustom:=1, MatchCase:=False, _
      Orientation:=xlTopToBottom
End Sub

Book1.xlsm
	A	B	C
1	Name	Item 1	Item 2
2	Jane	1	a1
3	Jane	2	b2
4	Jane	3	a2
5	Julie	4	b3
6	Julie	5	a3
7	Julie	6	b4
8	Julie	7	a4
9	Julie	8	b5
10	Mary	9	a5
11	Sarah	10	b6
12	Sarah	11	a6
Sheet1

 

[Jd2023]

Thank you so much, it worked perfectly!

 

[vladimiratanasiu]

Thank you so much, it worked perfectly!

You're welcome, and thank you for the feedback.