The supr are listed in the top row with their employees below each name. All the employee names have been input in column B for this example.Column B would normally be empty. Is there a way to auto input the name of the supr for each person in Column A. The order of the employ name will change each day in column B but supr will stay the same. I have separated each group with a yellow highlight.

Hope I have not made this more confusing.