|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?
The intention behind this query is to simplify the review of excel sheets with engineering calculations.
Let us assume that column A contains the notations. cell A1 contains "Rfa" and cell A2 contains "Rra". Cell reference of cell B1 should be automatically renamed as "Rfa" (content in A1) and that of B2 as "Rra" (content in A2). If I am able to do this, then in cell B3, the formula for adding both can be written directly as "=Rfa+Rra". This can lead reading the calculations user-friendly. Are there any standard functions available in excel to do this? Any ideas? Thanks in advance. |
#2
|
||||
|
||||
Simply define a name for each cell (Formulas>Define Name). You can then use the names for your formulae.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Not quite following you when you write: " Cell reference of cell B1 should be automatically renamed as "Rfa" (content in A1) and that of B2 as "Rra" (content in A2)." Are you wanting to simply and automatically rename cell B1 Rfa and cell B2 Rra? If you want to auto rename those cells, then what is the prompt to do this? If as Macropod stated, you only want to name those cells then click in the cell you want to name, click Formulas > Name Manager > New then in the name box enter the "range name" you want to assign to that cell. Or click in the cell you want to name, go to the name box (to the left of fx in ribbon) and type the "range name you want to assign to that cell. To check yourself, click on Name Manager and you should see the name you assigned to that cell, along with the cell address. Hope that helps. If this is not what you are wanting to do, take a minute, take a deep breath, sit down, while in Excel go through the steps you want done and at the same time write them down so all can better understand what it is you want to accomplish. See? Best wishes.
|
#4
|
|||
|
|||
Or simply overwrite the cell reference in the Name Box (to the left of the formula in the formula bar).
Excel built in table automation does this too in a different way and the naming, as far as formulas go anyway, carry down an entire table of values. * Variables go in columns with the names in the headers (top row). * Home:Styles:Format as table The formula, once entered, in each cell in the last column will be =[@RFA]+[@RRA]. |
#5
|
|||
|
|||
Concur with GeBobs
He is much, much more knowledgeable than I. However, I will say that sometimes, in rare instances, the "novice" can come up with something novel and unique.
Also, this has been my observation from reading numerous blogs on Excel and VBA. I think we all can learn something from this observation. Sometimes, the novice has a hard time conveying to the expert, in understandable terms to the expert, what the problem is they are encountering. Likewise, sometimes the "expert" has a hard time conveying to the "novice," in terms the novice understands, how to fix the problem. It's all about COMMUNICATION!! I think the "monkey is on the expert's back" to step back and ask himself or herself, "...is what I am writing understandable to someone who may not be as conversant as I am in Excel and/or VBA. Just a thought. Best week's wishes to all. |
#6
|
|||
|
|||
Yep, that's always a challenge. And I am regularly on the novice as well as the expert side of that communication breakdown.
That's why attached sample files go so much further than descriptions only or even screen captures. I thought I could get away without, but if you (who apparently has a breadth of Excel knowledge) don't understand me, what hope is there that the OP does? Anyhoo...here are a few screen captures of the Name Box that I was talking about. In this case, I selected the A1 address in the Name Box and typed RFA in it to quickly name the cell. Attached is a sample file of the table automation and the resulting formulas. See in Column C how the formulas are descriptive rather than merely referring to addresses. I'm not sure if this makes my original post any clearer. |
#7
|
|||
|
|||
I am certainly in the NOVICE category GeBobs!! You write very clearly and effectively!!
Am hoping to learn lots on here as it was suggested to me for a learning avenue. Best week's wishes!! Mort (Sgt Rock - childhood comic book hero) |
#8
|
|||
|
|||
Bah...anyone that knows how to name ranges and can write VBA as I've seen you do is well beyond novice. :-)
|
Tags |
cell references, naming cells |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell Background Color: Base it on Content of Cell? | tatihulot | Excel | 4 | 08-14-2013 03:24 PM |
How to input the text of a cell into another cell automatically ? | Juliet | Excel | 1 | 03-15-2013 03:25 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |