data

[Karel]

data won't repeat names in column. example
A1=my name B1-B13 various data for me
A14=your name B14-B23 various data for you

how do I get my name in A2-A13 and yours in A14-A23?

it's never the same names or rows of data.

Thank you very much!

 

[Gord Dibben]

Select column A and F5>Special>Blanks>OK

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

Hit CTRL + ENTER to insert formulas with the missing names.

You can then copy column A and Edit>Paste Special>Values>OK>Esc to get rid of
the formulas.


Gord Dibben MS Excel MVP

 

[FSt1]

hi
what method are you using now that isn't working?

regards
FSt1

 

[Karel]

just copy down manually. too large to do that.

hi
what method are you using now that isn't working?

regards
FSt1

 

[Karel]

Is there any way to automate so I don't have to do this with every new data
run?

 

[Gord Dibben]

Record a macro whilst doing the steps.


Gord

Is there any way to automate so I don't have to do this with every new data
run?