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