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

hi,
am try to do with your code but am getting the error.

please how to execute the code or

i'm attaching the file kindly insert the code and send to me.

information required: can is use any number of records in this code.


regards
Josh