If your data is in the proper format, you could create a Pivot Table on the
2nd worksheet.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Jenny" wrote:

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