I have weekly time broken down by category, however, only the total line has
the corresponding names. How do i fill the above cells with the corresponding
name on the total line. For example(where blank insert last name on total
line)
Col A Col D
blank wk27
blank wk28
blank wk29
blank wk30
Smith Total
blank wk27
blank wk28
blank wk29
johnson Total

thanks