data
 

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!

data
 

Select column A and F5SpecialBlanksOK

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 EditPaste SpecialValuesOKEsc to get rid of
the formulas.


Gord Dibben MS Excel MVP

On Sun, 2 Dec 2007 20:07:00 -0800, Karel
wrote:

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!

data
 

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

regards
FSt1

"Karel" wrote:

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!

data
 

just copy down manually. too large to do that.

"FSt1" wrote:

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

regards
FSt1

"Karel" wrote:

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!

data
 

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

"Gord Dibben" wrote:

Select column A and F5SpecialBlanksOK

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 EditPaste SpecialValuesOKEsc to get rid of
the formulas.


Gord Dibben MS Excel MVP

On Sun, 2 Dec 2007 20:07:00 -0800, Karel
wrote:

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!

data
 

Record a macro whilst doing the steps.


Gord

On Tue, 4 Dec 2007 08:21:01 -0800, Karel
wrote:

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

"Gord Dibben" wrote:

Select column A and F5SpecialBlanksOK

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 EditPaste SpecialValuesOKEsc to get rid of
the formulas.


Gord Dibben MS Excel MVP

On Sun, 2 Dec 2007 20:07:00 -0800, Karel
wrote:

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!