How to copy copy a line in excel using a specific word and pasting to another excel sheet
===

I have checked a bunch of different posts and cant seem to find the exact code i am looking for. Also i have never used VBA before so im trying to take codes from other posts and input my info for it to work. No luck yet. At work we have a payroll system in excel. I am trying to search for my name Clarke, Matthew and than copy that row and paste it to the workbook i have saved on my desktop "Total hours". Thanks.