Show pages

[Clyde Lomax]

I was recently introduced to this really helpful item on a Pivot table (show
pages).

Now if someone would be so kind as to let me know how to do something
similar from a worksheet I would be Grateful.

A B C
1 1 6 9
2 2 7 8
3 3 3 3
4 3 4 1
5 2 6 4
6 1 6 6

What the end result would be is tabs Named 1, 2 & 3 with the data for each
row on the new sheet, all 1's together, all 2's together.etc

Thanks in advance.
Lomax

 

[Clyde Lomax]

All of the 1,2,and 3... in column "A".

forgot to add this.

thanks lomax