Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-17-2014, 10:59 PM
bharathkumarst bharathkumarst is offline Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Windows 7 64bit Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Office 2010 64bit
Novice
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?
 
Join Date: Sep 2014
Location: Pune, india
Posts: 1
bharathkumarst is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 09-18-2014, 03:01 AM
macropod's Avatar
macropod macropod is offline Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Windows 7 64bit Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 10-12-2014, 07:26 PM
Sgt Rock Sgt Rock is offline Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Windows 8 Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Office 2010 64bit
Novice
 
Join Date: Nov 2013
Location: Dallas, Texas
Posts: 16
Sgt Rock is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 10-13-2014, 05:19 AM
gebobs gebobs is offline Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Windows 7 64bit Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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].
Reply With Quote
  #5  
Old 10-13-2014, 08:28 AM
Sgt Rock Sgt Rock is offline Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Windows 8 Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Office 2010 64bit
Novice
 
Join Date: Nov 2013
Location: Dallas, Texas
Posts: 16
Sgt Rock is on a distinguished road
Default 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.
Reply With Quote
  #6  
Old 10-13-2014, 09:17 AM
gebobs gebobs is offline Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Windows 7 64bit Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Attached Files
File Type: xlsx RFA+RRA.xlsx (8.9 KB, 8 views)
Reply With Quote
  #7  
Old 10-13-2014, 09:38 AM
Sgt Rock Sgt Rock is offline Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Windows 8 Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Office 2010 64bit
Novice
 
Join Date: Nov 2013
Location: Dallas, Texas
Posts: 16
Sgt Rock is on a distinguished road
Default

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)
Reply With Quote
  #8  
Old 10-13-2014, 10:25 AM
gebobs gebobs is offline Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Windows 7 64bit Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Bah...anyone that knows how to name ranges and can write VBA as I've seen you do is well beyond novice. :-)
Reply With Quote
Reply

Tags
cell references, naming cells

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? Cell Background Color: Base it on Content of Cell? tatihulot Excel 4 08-14-2013 03:24 PM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft