AutoPopulate Cells

[khuff]

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.

 

[Sheeloo]

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

 

[Gord Dibben]

Select the column and F5>Special>Blanks>OK

Type an = sign in active blank cell then point or arrow to cell above.

CTRL + ENTER to fill the blank cells.

Copy/paste special.values/ok/esc


Gord Dibben MS Excel MVP

 

[ShaneDevenshire]

Hi,

You should reconsider Gord's suggestion, it is the method of choice for
solving these types of problems and it will work on multiple columns. You
should give Gord's solution a check Yes.

 

[khuff]

Hey Gord,

I used the formula Sheeloo gave me and it worked great although I had to
pull the fill tool for awhile before I was finished.

As Shane says your suggestion seems to be the preferred method and I will be
trying it the next time I download and convert one of these documents I have
to work with. Thanks to all of you for the help and sorry for taking so long
to reply.

 

[khuff]

Works like a champ! Wish I would have asked about this a long time ago.

Thanks Again