Numbers - How do I select certain rows?

I have a Numbers doc of my bank account. I can 'Sort and Filter' so that it displays only my monthly wage paid in by my employer.

But how can I then actually copy those 30 or so rows and then paste them into another new doc? If I select all and then copy/paste, it copies ALL rows - even those hidden after doing the search.

Any help?

 

If you re-read my original post, you'll see the problem.

If I have a doc of 150 rows and do a filter that then only shows (say) rows 3, 30, 45, 90 and 105 and then copy and paste, it will copy and paste ALL rows (1-150).