Help me with this macro

[rcdgreat]

I need help in creating this macro. What I would want to do is when filter to a specified value the macro will automatically select the filtered rows but here's the catch it would select how many rows in the filtered rows depending on a value given.

For Example sorry if it's quite confusing to discuss:

Assuming I have already filtered column A for cell containing value named "Sample" out of 400 records it have filtered 48 records. And I would only want 10 out of the 48 records to be copied in another sheet.

Please help thanks. More power.

 

[Comfy]

The only way I could think of doing this would be:

Sub Selection()
    Cells(1, 1).Offset(10, 0).Select
    Rows("1:" & ActiveCell.Row).Copy
End Sub

Assuming Headers in Row 1 this will copy the Headers and the Next 10 Rows.

 

[rcdgreat]

Thank you very much bro... It's working just the way I want I've just tweaked some parts.