How to appy range names to formulas which use single cells in rang

[Dima]

Hello!
How to appy a thousand new range names to formulas which use corresponding
single cells in the ranges?
Regards,
Dmitry

 

[Duke Carey]

Dmitry -

Several of your questions have been short, general, and vague to the point
of not posing a question that can be answered. Please provide better detail
and explanation of what you are trying to do.

 

[Dima]

Hello!
How to replace thousands of single cell references (for example, A1) with
row names? The formulas and its precidents are in a same column.
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 cells like D1000 and row names like the rowName.
Regards,
Dmitry

 

[Duke Carey]

Insert->Name->Apply

That may require you to go through each range name, one at a time, though.

If so, you could

 

[Dima]

Thanks Duke Carey for replying!
Insert->Name->Apply would apply the row names (rowName) to the rows (first
row) only. Insert->Name->Apply does not apply the row names (rowName) instead
of the single cell references like D1000 =D1 in my example.
There is about a thousand such names on the sheet.
Please, help!
Regards,
Dmitry

 

[Dima]

Thanks Duke Carey for replying!
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).
There is about a thousand such names on the sheet.
How to replace the single cell references with the row names?
Regards,
Dmitry