| 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
|
|||
|
|||
|
How to name many rows by values in a column on the same sheet at o
InsertNameCreate
Must have two columns selected. Gord Dibben MS Excel MVP On Thu, 7 Aug 2008 06:24:01 -0700, Dima wrote: 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
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
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
|
|||
|
|||
|
How to name many rows by values in a column on the same sheet
Thanks Gord Dibben for replying!
One of the "two columns" is the column with future row names, isn't it? What is the second column? Regards, Dmitry "Gord Dibben" wrote: InsertNameCreate Must have two columns selected. Gord Dibben MS Excel MVP On Thu, 7 Aug 2008 06:24:01 -0700, Dima wrote: Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry |
|
#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
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 |
|
#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
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. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to name many rows by values in a column on the same sheet
Should have said..........at least two columns.
The column(s) to the right of the desired names will be the named range. The leftmost column cells will be the defined name. i.e. Column A bert gord dima pete Data in columns B:F Select A:F and InsertNameCreateLeft column bert will refer to B1:F1 gord will refer to B2:F2 Gord On Thu, 7 Aug 2008 22:41:00 -0700, Dima wrote: Thanks Gord Dibben for replying! One of the "two columns" is the column with future row names, isn't it? What is the second column? Regards, Dmitry "Gord Dibben" wrote: InsertNameCreate Must have two columns selected. Gord Dibben MS Excel MVP On Thu, 7 Aug 2008 06:24:01 -0700, Dima wrote: Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry |
|
#11
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. |
|
#12
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 | |||
| How can I SUM all values in a column where the rows... | Excel Worksheet Functions | |||
| Incorporating the first 40 out of 250 rows in column values | Excel Worksheet Functions | |||
| conditional formatting rows on column values... | New Users to Excel | |||
| Paste Values in Number of rows as count in other sheet | Excel Discussion (Misc queries) | |||
| VBA to set AutoFilter to List all rows with same values in column? | Excel Discussion (Misc queries) | |||
Linear Mode
