macro to copy paste filtered data

Hi Champs,

I have a huge date with 5000 rows todays and may be more tomorow...
the fields are code, id number and schedule number and error 1 to error 20.

i need to filter the error column . say f and filter "Yes" and then copy the corresponding code number and ID number to output sheet (last row of the output sheet).
like this i need to filter manually from f column till W column. please help me with a macro. i have attached a sample file.View attachment sample.xlsx

Cross posted and solved here: http://www.excelforum.com/excel-pro...-copy-paste-filtered-data.htmlExcelhelpseeker, please have a read of this article: http://www.excelguru.ca/content.php?184