VBA Code to filter,Copy and Paste data from one sheet to the other

Hi Excel Gurus,

Could any one please help in Filter Data by "roll no" in the before sheet and copy the data and paste specific data in the after sheet.

I have collective data in my Before sheet where the Column has Mark1 to Mark 9.

However i want a certain data only to be pasted in my after sheet. That is

I want certain roll numbers to be pasted with the name.

In Marks column i require only Mark2, Mark 4, Mark 6, Mark 8, Mark 9 only for the particular roll no.

Here with i have attached my Sample work book containing Before and after sheet for your reference.

Kindly help me in completing this copy and pasting through VBA coding.

Thanks a lot in advance for your help.

Regards,

Aravind

Try the attached.