In column C is the name of an employee follwowed by lines of data for
that employee with no further data in column C until the next employee. This
sequence repeats itself for 48,000 lines.
Is there a formula/macro that will copy the employee name into the next
row of column C until the name changes and then repeat for the next name?