How do I store through a cell that contains a cell address in it?

[Big Gray Cat]

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!

 

[Gary''s Student]

Consider using a macro:

Sub kitty()
adrs = Range("J20").Value
Range(adrs).Value = Application.InputBox(prompt:="Enter datum:", Type:=1)
End Sub

make sure you have already loaded the correct address in J20 and then run
the macro.

 

[Jim Thomlinson]

A formula can only affect the cell that it is in. It can not write to another
cell. Either look at using Gary's macro or you will need to re-engineer your
solution...