Ctrl find, copy and pasting help please (Macro code needed)

Originally Posted by arlu1201

I am working out something for you. I have a question. When the data is found, should it be copied to the next available row in the excel spreadsheet or just below the header?

The header row in both spreadsheet will be contant so the data when the header/payroll component is found then I want the data pasted directly below the header row so from row 2 onwards

many thanks