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

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

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

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

Rick


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

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

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
"Rick Rothstein (MVP - VB)" wrote:

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

Rick


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

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

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" wrote:

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
"Rick Rothstein (MVP - VB)" wrote:

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

Rick


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

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

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
"Barb Reinhardt" wrote:

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" wrote:

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
"Rick Rothstein (MVP - VB)" wrote:

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

Rick


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

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

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.
--
HTH,
Barb Reinhardt



"Dima" wrote:

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
"Barb Reinhardt" wrote:

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" wrote:

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
"Rick Rothstein (MVP - VB)" wrote:

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

Rick


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

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

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.

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

The number of the row is not in the name.

"Spiky" wrote:

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.

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

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
"Barb Reinhardt" wrote:

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.
--
HTH,
Barb Reinhardt



"Dima" wrote:

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
"Barb Reinhardt" wrote:

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" wrote:

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
"Rick Rothstein (MVP - VB)" wrote:

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

Rick


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