Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 90
Default How to appy range names to formulas which use single cells in

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
converting email address names in a range of cells to real names John Excel Worksheet Functions 1 May 19th 10 03:44 PM
How to appy range names to formulas which use single cells in rang Dima Excel Discussion (Misc queries) 5 August 10th 08 09:55 AM
How to appy range names to formulas which use single cells in rang Dima Excel Worksheet Functions 5 August 10th 08 09:55 AM
Copy column range of "single word" cells with spaces to a single c nastech Excel Discussion (Misc queries) 3 February 15th 06 05:04 PM
How do i separate full names appearing in single cells? daveylee Excel Worksheet Functions 3 January 18th 06 09:51 PM


All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"