Assign the value of a cell as a cell reference of another cell in Excel 2010

		Microsoft Office Forums > Microsoft Excel > Excel
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?

FAQ

Thread Tools

Display Modes

10-13-2014, 05:19 AM

gebobs

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

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].

Tags

cell references, naming cells

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:58 PM.