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

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

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

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

> 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" wrote:
>
> > Hello!
> > How to appy a thousand new range names to formulas which use corresponding
> > single cells in the ranges?
> > Regards,
> > Dmitry

Insert->Name->Apply

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

If so, you could

"Dima" wrote:

> 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" wrote:
>
> > 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" wrote:
> >
> > > Hello!
> > > How to appy a thousand new range names to formulas which use corresponding
> > > single cells in the ranges?
> > > Regards,
> > > Dmitry

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

> Insert->Name->Apply
>
> That may require you to go through each range name, one at a time, though.
>
> If so, you could
>
> "Dima" wrote:
>
> > 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" wrote:
> >
> > > 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" wrote:
> > >
> > > > Hello!
> > > > How to appy a thousand new range names to formulas which use corresponding
> > > > single cells in the ranges?
> > > > Regards,
> > > > Dmitry

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

> Insert->Name->Apply
>
> That may require you to go through each range name, one at a time, though.
>
> If so, you could
>
> "Dima" wrote:
>
> > 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" wrote:
> >
> > > 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" wrote:
> > >
> > > > Hello!
> > > > How to appy a thousand new range names to formulas which use corresponding
> > > > single cells in the ranges?
> > > > Regards,
> > > > Dmitry