Is there a way to take say a name and group # from one sheet and seperate by
group # on the next sheet.
example.
Page 1
name 1 group a
name 2 group b
name 3 group a

Page 2
Group a
name 1
name 3

group b
name 2