Hi,

I need to set the values (Peoples names) of a column according to the fill
color of each row.

Can anyone please point me in the right direction with this problem.

I'm a VBA newbie by the way!


Regards,
Ron.