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?

09-18-2014, 03:01 AM

macropod

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: 22,512

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]

Tags

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 03:46 AM.