Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Restoring formulas after deleting range names | Excel Worksheet Functions | |||
How do you set up range names, name formulas | Excel Worksheet Functions | |||
Sumif referring to range names formulas not updating | Excel Worksheet Functions | |||
Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
How do i separate full names appearing in single cells? | Excel Worksheet Functions |