| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I store through a cell that contains a cell address in it?
I have an Excel (2003) cell that contains a derived address of another cell
in my spreadsheet. For example I may be at Cell j20, and in that cell I have the absolute addtess $B$16. I want to set $B$16 to a specific value. This address can change, so I can't just "hard code" the $B$16 somewhere else. I have to do an indirect store through J20 TO $B$16, and place my datum at $B$16. However, $B$16 can change with respect to other conditions in the sheet. I can do the equivalent of a "Load Indirect" easily. How do I do a "Store Indirect". Thankx! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Store cell value and set to zero | Excel Discussion (Misc queries) | |||
| store address in a cell and use it in formula | Excel Discussion (Misc queries) | |||
| Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
| Store max value of changing cell | Excel Worksheet Functions | |||
| store some of the information from one cell into another | Excel Discussion (Misc queries) | |||
Threaded Mode
