If this is what you're looking for...

Smith wk27
Smith wk28
Smith wk29
Smith wk30
Smith Total
johnson wk27
johnson wk28
johnson wk29
johnson Total

....try the following...

1) Select your data in Column A

2) Edit Go To Special Blanks Ok

3) Tab down to the blank cell just before the first name, in this case A4

4) Press =

5) Hit the 'Down Arrow'

6) Hit CONTROL+ENTER

Hope this helps!

In article ,
"jerry" wrote:

How do i fill the cells above with the corresponding
name on the total line with that name. For example
Col A Col D
blank wk27
blank wk28
blank wk29
blank wk30
Smith Total
blank wk27
blank wk28
blank wk29
johnson Total

thanks
Jerry