Hello!
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 =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

Rows(1) = D1.value



"Dima" wrote:

Hello!
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 =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

Thanks Joel for replying!
Is the
Rows(1) = D1.value
a VBA code? Does the code replace the D1 reference with a name of the first
row?
How to replace all single cell references with names of rows (in which the
cells are) on a sheet at once?
Regards,
Dmitry
"Joel" wrote:

Rows(1) = D1.value



"Dima" wrote:

Hello!
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 =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