Try this:

1. Select the cells in column A
2. Press F5
3. Select 'Blanks'
4. Click OK
5. Type '=' (without the quotes)
6. Press the Down Arrow once
7. Press Control Enter

now, in order to make those changes permanent, select the entire column,
copy it, then go to Edit | Paste Special, and select 'Values'.

--
Regards,

Juan Pablo González
Excel MVP

"jerry" wrote in message
...
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