Vba data move in another sheet as per requirement

[sa.1985]

Dear Sir,


Please find the attached workbook.

At present this workbook working simply as move data in another sheet as per column c ( name ).

Here my requirement is that . i want to some columns data in one sheet ( i have attached in last sheet named "scrap")

If MODE OF PAYMENT = Scrap then sheet1's data of scrap move in scrap sheet.

here sheet1's all scrap data will move in sheet scrap.