Sorting the content of a table in separate sheets?

[fanch72]

Hi,
I have a table in one Excell sheet. The table looks like this:

A B C D E F G
1 v1 v2 v3 v4 v5 v6 a1, a3
2 v7 v8 v0 v1 v2 v1 a2
3 v4 v6 v2 v1 v7 v3 a1, a4, a5
...
N

SHEET1


I want to convert it so that I get the following file:
A B C D E F
1 v1 v2 v3 v4 v5 v6
2 v4 v6 v2 v1 v7 v3
SHEET Name: a1

A B C D E F
1 v7 v8 v0 v1 v2 v1
SHEET Name : a2

A B C D E F
1 v1 v2 v3 v4 v5 v6
SHEET NAME: a3

A B C D E F
1 v4 v6 v2 v1 v7 v3
SHEET NAME: a4

and so on. a1, a2... are names, so are v1, v2...

Has someone a good idea on how to do this?
Thanks a lot

Francois

 

[01Patrik]

I believe the easiest way of accomplishing this is to use the autofilter to filter out each name. When filtering, use "(Custom)" and select "contains" in the drop-down box. Then filter for each name, copy the entire rows (NOT just the data range) and paste in a separate sheet.


If the values are numbers, and what you need is to summarize the numbers, then there are other ways to go about. Is that the case?

// Patrik