moving data from one sheet to another

[rjagathe]

I have records in sheet1 as follows:

A B C D E
1 NAME SEX SUBJECT COLLEGE WHETHER SELECTED

2 A MALE MATHS XAVIER YES

3 B FEMALE ENGLISH SEBASTIAN

4 C FEMALE MATHS PAULS

5 D MALE PHYSICS XAVIER YES

6 E MALE CHEMISTRY PAULS YES

7 F MALE PHYSICS SEBASTIAN YES

8 G FEMALE MATHS XAVIER YES

9 H MALE PHYSICS PAULS

10 I MALE MATHS SEBASTIAN

Now, I want to scan entire data upto last cell of the
range and move(cut and paste) those of the selected candidates, Sheet2
of the same book.After moving, the name of the Sheet should be changed
to "seleted students". Then, I want to select all the remaining
records in sheet 1 (4 in number) and sort them in the following
order :SUBJECT,SEX, COLLEGE.
Please help.

 

[Don Guillett]

Use data>filter or sort to get desired>copy/paste>sort.
Record a macro>clean it up