Please I need help to change the corresponding cell to another cell based on the first cel

[mido609]

Kindly find check the attached file for all details

[sktneer]

Please find the attached sheet to see if this is what you want.

[mido609]

Thanks Alot for your quick response and this is 70% of what I need,

I just need the drop down box to read automatically what exist in each column, without using .additem comman

So if the values changed in name columns the values also should change in the drop down box

is that possible?

[sktneer]

OK. Now see the attached sheet.