copy or remove particular count of records and pasting in another excel workbook

Hi,

i have 1000 records, how can i make it,

u have given the solution but, its work only one criteria but criteria may change.

please help me solve.

josh.