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

Thanks Again

"ShaneDevenshire" wrote:

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.

--
Cheers,
Shane Devenshire


"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.