Picking data
 

Hi
Can anyone help me how to pick data from a table. The table is sorted on one
column and I want to build a new table with rows wich have a specifc data in
one column.
It is a result list with name, club, klass and points (result)
I want a new list for each klass.
The main list looks i.e. like this:
Tomas Smith - "club" - HC19 - 567
Linda Calway - "club" - DC19 - 544
Franc Moy - "club" - HC19 - 537
and so on

The new list shall have only HC19
Tomas Smith - "club" - HC19 - 567
Franc Moy - "club" - HC19 - 537

The main list will change from competion to competion and I want to have a
new "klass list" each time.

try data-filter-autofilter
see help or
the following url

http://www.contextures.com/xlautofilter01.html
of debra Dalgleish



Tudor wrote in message
...
Hi
Can anyone help me how to pick data from a table. The table is sorted on
one
column and I want to build a new table with rows wich have a specifc data
in
one column.
It is a result list with name, club, klass and points (result)
I want a new list for each klass.
The main list looks i.e. like this:
Tomas Smith - "club" - HC19 - 567
Linda Calway - "club" - DC19 - 544
Franc Moy - "club" - HC19 - 537
and so on

The new list shall have only HC19
Tomas Smith - "club" - HC19 - 567
Franc Moy - "club" - HC19 - 537

The main list will change from competion to competion and I want to have a
new "klass list" each time.

Tnx. How easy it was.



"R.VENKATARAMAN" skrev:

try data-filter-autofilter
see help or
the following url

http://www.contextures.com/xlautofilter01.html
of debra Dalgleish



Tudor wrote in message
...
Hi
Can anyone help me how to pick data from a table. The table is sorted on
one
column and I want to build a new table with rows wich have a specifc data
in
one column.
It is a result list with name, club, klass and points (result)
I want a new list for each klass.
The main list looks i.e. like this:
Tomas Smith - "club" - HC19 - 567
Linda Calway - "club" - DC19 - 544
Franc Moy - "club" - HC19 - 537
and so on

The new list shall have only HC19
Tomas Smith - "club" - HC19 - 567
Franc Moy - "club" - HC19 - 537

The main list will change from competion to competion and I want to have a
new "klass list" each time.