Search list for required data copy/paste row

[redspanna]

Hi all

I would like some code that will search through column D of sheet "LOG" for the name "ANTHONY" - when found copy the entire row where "ANTHONY" is found and paste onto next available row in SHEET2
Loop this until all rows in sheet "LOG" have been searched

Result will be a seperate data log in SHEET2 that ALL have the words ANTHONY

Any help appreciated and thanks in advance

 

[MrKowz]

Why write a code for this? You can autofilter for Anthony and copy/paste the result manually. Is this needed for a large number of names which causes the task to become more laborous?

 

[redspanna]

Hi and thanks for ur reply,

There are only 3 names to search for and I want each one found to be listed (together with corresponding data) on a separate sheet.
I would prefer code for this as it is to be incorporated into a userform

thanks again and hope you can help further

 

[redspanna]

No worries on this one Guys
I have played around (for the first time) with the Autofilter and created some code using the macro record function.......

we live and learn !!