Search Array Terms Copy Row Other Sheet

[Logit]

.
The following is only selecting the last term in the stated Array of names and pastes that name to the other sheet. Why is it not finding each of the Array names and pasting
them to the other sheet ? Thank you.

Please Login or Register  to view this content.

[jindon]

Because you are pasting to same cell all the time

Please Login or Register  to view this content.

Needs to be

Please Login or Register  to view this content.

[AB33]

You mean

Please Login or Register  to view this content.

[Logit]

.
AB33 : Thank you for the response. No go with your suggestion. Sorry.

jindon : Ok, that works EXCEPT it's copying PETE twice. ???

[Logit]

.

Never mind. Just saw I had PETE listed twice in the main list. Duh !

Thanks guys !

[AB33]

What do you mean by

No go with your suggestion. Sorry?
You have finnext function and have two pete

[jindon]

You are welcome and thanks for the rep.

[Logit]

.
AB33

I copied pasted the macro into the workbook. It provided the same results as my macro.

[AB33]

Well, Should the last row be on Worksheets("Central") or Set wSht = Sheets("Intern")?

If you are copying in to sheet Set wSht = Sheets("Intern"), then

Please Login or Register  to view this content.

Although it is technically not wrong, I use Dim strLastRow As long

[Logit]

.
It is copying to Sheets("Intern") ... however, it is only copying one name. Not all the names listed in the Array.

[AB33]

This line

Please Login or Register  to view this content.

and these two lines:

Please Login or Register  to view this content.

are the same

If the intention is the first one, you do not need to use another variable.

[Logit]

.
This is the line that made the difference :

Please Login or Register  to view this content.

[AB33]

I understand though, I did not get it why you need this line then

Please Login or Register  to view this content.

?

I interpreted to mean something when you included it, but looking back, that created some confusion.