How to name many rows by values in a column on the same sheet at o

[Dima]

Hello!
How to name many rows by values in a column on the same sheet all at once?
Regards,
Dmitry

 

[Rick Rothstein \(MVP - VB\)]

Can you describe what you want to do in more detail for us?

Rick

 

[Dima]

Thanks Rick for replying!
I entered thousand future row names in a column. Now I want to name all
thousand rows with corresponding names in the column, and then apply all them
in existing formulas in the workbook.
Regards,
Dmitry

 

[Gord Dibben]

Insert>Name>Create

Must have two columns selected.


Gord Dibben MS Excel MVP

 

[Barb Reinhardt]

What exactly do you want to do in the calculations? Give an example of a
value in a cell and how it might be used. I'm not clear on why you need
1000 named ranges.

Barb Reinhardt

 

[Dima]

Thanks Barb Reinhardt for replying!
The calculations should use the future row names to use corresponding values
in the rows.
An example of a value in a cell in the row names column:
A11rowName
Formulas in a 20th row will use A11rowName to take values in corresponding
cells in the 11th row.
There are about a thousand rows with values and formulas which use the
values. I want to replace meaningless cell references with meaningfull row
names in the column with future row names.
Regards,
Dmitry

 

[Dima]

Thanks Gord Dibben for replying!
One of the "two columns" is the column with future row names, isn't it?
What is the second column?
Regards,
Dmitry

 

[Barb Reinhardt]

I can't help unless I know specifically what you want to do. What are the
formulas in the 20th row (by cell if possible) and what is the A11RowName?
What's in A11.

 

[Spiky]

I can't help but wonder if 1000 names, with the number of the row in
the name, aren't going to be exactly the same level of
"meaningfullness" as just using actual cell references.

 

[Gord Dibben]

Should have said..........at least two columns.

The column(s) to the right of the desired names will be the named range.

The leftmost column cells will be the defined name.

i.e.

Column A

bert
gord
dima
pete

Data in columns B:F

Select A:F and Insert>Name>Create>Left column

bert will refer to B1:F1
gord will refer to B2:F2


Gord

 

[Dima]

The number of the row is not in the name.

 

[Dima]

Thanks Barb Reinhardt for replying!
How to appy a thousand new row names to formulas which use corresponding
single cells in the rows? or How to replace thousands of single cell
references (for example, A1) with row names? The formulas and its precidents
are in same columns.
For example:
row name: rowName = $1:$1
The formula in D1000 is =D1
How to replace =D1 with =rowName in cell D1000 automatically?
There are thousands of cells like D1000 and row names like the rowName.
Insert->Name->Apply would apply the row names (rowName, in my example) to
the rows (first row, in my example) only. Insert->Name->Apply does not apply
the row names (rowName, in my example) instead of the single cell references
(=D1 in D1000 cell in my example).
Regards,
Dmitry