Copying Found Data to Another Sheet
There is an Excel file that teaches how to perform the Copying Found Data to Another Sheet operation.
Excel Format: Copying Found Data to Another Sheet
This workbook searches through over 2000 rows of data across four columns and copies matching records to a second sheet using VBA.
Hope it is useful.