Copying sub sets.
 

At conclusion of filtering a subset,
we want to dump the records to MSWorks.

Not all records (rows) are copied over.

Can someone advise the accepted way of doing this please.
Do I have to copy the subset to another worksheet , then copy?

Thanks