Loop through a list of names which has below certain data and show in the beside column only the corresponsive name

[gerti]

Dear All Chandoo Members,

First I wish all of you and your loved ones are healthy and well.

I would appreciate if you could help me with an issue I have.

I have a column with a list of persons and below I have some elements (types) which belong to the name. However in the column range, a new name appears with the respective elements. The issue is that there are different elements for different name and there is no pre-determined nr of rows when the name appears.

In the "H" Column I want to show the name as it is shown in the below picture.

There is the list of elements in another excel sheet as in the other picture below. (sheet Liste Metoda pagese).

Note that the list in column "A" may go to hundreds or thousands and it consumes a lot of time to do manually.

You could help me with the answer in VBA or formula, no problem.

I hope to have been clear in my question.

Hope to receive some help from the members of this forum.

Wishing the best for you all!

Gerti

 

[vletm]

gerti
Write to cell H2 =IF(E2="",A2,H1) and copy down.

 

[gerti]

Man,

You are truly a Ninja.

It was so easy and I have been looking for VBAs for the last 4 hours.

You are da real MVP!

 

[vletm]

gerti
Now, You could do it Yourself with VBA too.