Thread: [Solved] Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?
View Single Post
 
Old 10-13-2014, 05:19 AM
gebobs gebobs is offline Windows 7 64bit 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