CAPTURE INFO FROM PAGE TO PAGE

[Jenny]

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

 

[Gary Brown]

If your data is in the proper format, you could create a Pivot Table on the
2nd worksheet.