Repeated tasks with different values to be run with Macro

Hello Team,

I have an excel file from my client that has two cells with search criteria. When I enter the last name and first name it displays a set of values that I need to copy & paste special against each name.
I can copy paste the list of names to a new tab in the client sheet.

What I want the macro to be able to do is for it to copy first name from list paste it in search field then copy last name & paste it in the search field and copy the resulting out put against the name in column against the name.

I have a list of thousand names, so the macro should be going to second raw then third and repeat the process.

Please advise how I can loop it.

Thank you,
Antony Thomas

Hi,

I cant upload the excel as such as it is a client data but I can provide screen shots to what I am looking for.
I have attached the word document.

You will notice in sheet three I have the first 7 second name I have concatenated the names to create the full name & the search cells are present in sheet 1. Below the search columns you will see the list of emails being generated.

The generated emails needs to be copy pasted (values & transpose) against the full name.

Then the macro needs to pick the second row data & repeat the process.

let me know if you can help me here.

Thank you,
Antony thomas