VBA to search for multiple values in one sheet then copy to another sheet

Hi there
Here’s the issue:

I have three sheets….
Sheet1 has the Data
Sheet 2 is blank
Sheet3 has the search Names {there are about 100 rows with name values}

I want to search Sheet1 for all occurrences of where the name values from Sheet3 might occur, and then copy them to Sheet2.
I have no idea where to start because I need the search to loop to search for the next name value from Sheet3.

I have attached an example of the workbook layout; however there is no code.
I know how to do a basic search and copy code, but I am unsure how this will work when the search value is held in 100+ rows on Sheet3.

Here’s a little sample of what I am trying to do…….


SHEET 1: (has many rows of data i need to search through)
SHEET 2: (is currently blank, and is where the output from the search will go)
SHEET 3: (has Coloum "A' filled with rows of names like DLPTPAYR or DLSYCNTY. These are table names, and I am searching a script from SHEET1 to see if these table names from SHEET3 appear on SHEET1 then copy them to SHEET2.

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

I have now found that the data source is actually spread over multiple columns not just A.
Is that an issue?

Originally Posted by DanzaNZ

I have now found that the data source is actually spread over multiple columns not just A.
Is that an issue?

Please Login or Register  to view this content.

Thank you Jindon
Truly amazing help!
Much appreciated!