How to move data from one cell to a variety of other cells. Indirect addressing?

I'm probably using the wrong terminology, which may be why I'm not having much luck searching the web.

This is what I want to do ... (abbreviated)

I have data in cell C2.

I want to move (copy?) the C2 data value to any one of a number of different cells (Dx), depending on the value in cell A1.

example: When the value in A1 is 4, data from C2 is moved to D4. When A1 is 12, data from C2 is moved to D12.

I also want this move to be a one-shot deal, only making the move when I trigger it (somehow).
If the value in C2 changes, I do not want it to change any of the destination cells until I give it a specific destination.

Essentially, I want to store the value in C2 to another cell.

I'm hoping there is a solution that doesn't require VBA. My expertise with Excel is ... limited.

Thx!

Thank you for the help.

However, the air velocity disappears from the destination cell when the case number is changed ... and it reappears in the new case number.

I'm looking for a way to "store" the value. So after I have performed ten case calculations, I would have all ten (yellow) case cells populated.

Move thread? - Ok

... am I asking too much, considering my meager Excel skills?

Hi sintek,

That is very close to what I am looking for.
Except, there is no need to prevent the overwriting of a yellow case cell.
How hard is it to add a button to actually trigger the fill?

In the end, I hope to apply this to approx 30 cell in a row (say ... E10:AH10)
... and fill the row of my choosing below row 10. Essentially storing those values so I can continue screwing around with the calculations.


Thanks for the help!

That works great!

Two reasons for a button ...
1. The added step of pushing a button will (hopefully) make it less likely to accidentally overwrite a storage cell.
2. Right now, if I want to overwrite the same storage cell that is currently shown in C4, I have to change C4 to a different value and then return to the case number I want. Hopefully, with a button I could repeatedly change the air velocity (C2), and keep dumping that value into the same storage cell without changing C4.

Awesome! Much appreciated.