Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name many rows by values in a column on the same sheet at o
Hello!
How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name many rows by values in a column on the same sheet at o
Can you describe what you want to do in more detail for us?
Rick "Dima" wrote in message ... Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name many rows by values in a column on the same sheet
Thanks Rick for replying!
I entered thousand future row names in a column. Now I want to name all thousand rows with corresponding names in the column, and then apply all them in existing formulas in the workbook. Regards, Dmitry "Rick Rothstein (MVP - VB)" wrote: Can you describe what you want to do in more detail for us? Rick "Dima" wrote in message ... Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name many rows by values in a column on the same sheet
What exactly do you want to do in the calculations? Give an example of a
value in a cell and how it might be used. I'm not clear on why you need 1000 named ranges. Barb Reinhardt "Dima" wrote: Thanks Rick for replying! I entered thousand future row names in a column. Now I want to name all thousand rows with corresponding names in the column, and then apply all them in existing formulas in the workbook. Regards, Dmitry "Rick Rothstein (MVP - VB)" wrote: Can you describe what you want to do in more detail for us? Rick "Dima" wrote in message ... Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name many rows by values in a column on the same sheet
Thanks Barb Reinhardt for replying!
The calculations should use the future row names to use corresponding values in the rows. An example of a value in a cell in the row names column: A11rowName Formulas in a 20th row will use A11rowName to take values in corresponding cells in the 11th row. There are about a thousand rows with values and formulas which use the values. I want to replace meaningless cell references with meaningfull row names in the column with future row names. Regards, Dmitry "Barb Reinhardt" wrote: What exactly do you want to do in the calculations? Give an example of a value in a cell and how it might be used. I'm not clear on why you need 1000 named ranges. Barb Reinhardt "Dima" wrote: Thanks Rick for replying! I entered thousand future row names in a column. Now I want to name all thousand rows with corresponding names in the column, and then apply all them in existing formulas in the workbook. Regards, Dmitry "Rick Rothstein (MVP - VB)" wrote: Can you describe what you want to do in more detail for us? Rick "Dima" wrote in message ... Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry |
#6
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name many rows by values in a column on the same sheet
I can't help unless I know specifically what you want to do. What are the
formulas in the 20th row (by cell if possible) and what is the A11RowName? What's in A11. -- HTH, Barb Reinhardt "Dima" wrote: Thanks Barb Reinhardt for replying! The calculations should use the future row names to use corresponding values in the rows. An example of a value in a cell in the row names column: A11rowName Formulas in a 20th row will use A11rowName to take values in corresponding cells in the 11th row. There are about a thousand rows with values and formulas which use the values. I want to replace meaningless cell references with meaningfull row names in the column with future row names. Regards, Dmitry "Barb Reinhardt" wrote: What exactly do you want to do in the calculations? Give an example of a value in a cell and how it might be used. I'm not clear on why you need 1000 named ranges. Barb Reinhardt "Dima" wrote: Thanks Rick for replying! I entered thousand future row names in a column. Now I want to name all thousand rows with corresponding names in the column, and then apply all them in existing formulas in the workbook. Regards, Dmitry "Rick Rothstein (MVP - VB)" wrote: Can you describe what you want to do in more detail for us? Rick "Dima" wrote in message ... Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry |
#7
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name many rows by values in a column on the same sheet
I can't help but wonder if 1000 names, with the number of the row in
the name, aren't going to be exactly the same level of "meaningfullness" as just using actual cell references. |
#8
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name many rows by values in a column on the same sheet
The number of the row is not in the name.
"Spiky" wrote: I can't help but wonder if 1000 names, with the number of the row in the name, aren't going to be exactly the same level of "meaningfullness" as just using actual cell references. |
#9
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to name many rows by values in a column on the same sheet
Thanks Barb Reinhardt for replying!
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 is =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 "Barb Reinhardt" wrote: I can't help unless I know specifically what you want to do. What are the formulas in the 20th row (by cell if possible) and what is the A11RowName? What's in A11. -- HTH, Barb Reinhardt "Dima" wrote: Thanks Barb Reinhardt for replying! The calculations should use the future row names to use corresponding values in the rows. An example of a value in a cell in the row names column: A11rowName Formulas in a 20th row will use A11rowName to take values in corresponding cells in the 11th row. There are about a thousand rows with values and formulas which use the values. I want to replace meaningless cell references with meaningfull row names in the column with future row names. Regards, Dmitry "Barb Reinhardt" wrote: What exactly do you want to do in the calculations? Give an example of a value in a cell and how it might be used. I'm not clear on why you need 1000 named ranges. Barb Reinhardt "Dima" wrote: Thanks Rick for replying! I entered thousand future row names in a column. Now I want to name all thousand rows with corresponding names in the column, and then apply all them in existing formulas in the workbook. Regards, Dmitry "Rick Rothstein (MVP - VB)" wrote: Can you describe what you want to do in more detail for us? Rick "Dima" wrote in message ... Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying rows values on one sheet to part of a formula in a column | Excel Discussion (Misc queries) | |||
How to name many rows by values in a column on the same sheet at o | Excel Discussion (Misc queries) | |||
How to name many rows by values in a column on the same sheet at o | Excel Worksheet Functions | |||
How can I SUM all values in a column where the rows... | Excel Worksheet Functions | |||
How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming |