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!
|