View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default AutoPopulate Cells

One way is to (assuming your list is in Col A)
type
=A1 in B1
Type
=IF(A2="",B1,A2) in B2 and copy down till the last row

Copy Col B and PASTE SPEICAL|VALUE over Col A
Delete Col B

"khuff" wrote:

I have a list of names in alphabetical order that occur in one column with
about 20 blank lines between each consecutive name.

Is there a tool in excel that will auto populate the cells directly below
each name with out having to copy/paste each. (there can be up to 500 names)
I tried to set up a macro but no luck.