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