Help with radio button

[Guest]

I have added a number of radio buttons to my spreadsheet and linked them to a
cell. I would like that Everytime I check one button information from the
cell copies autmatically to another cell. For example if I click on button 1
I would like information from cell A where button 1 is placed to copy to cell
D. Is there a way to do this. I know that there is a way to do this with
checkboxes but unfortunately I am only allowed to use radio buttons in this
specific spreadsheet for users are only allowed to choose one of the options.


Any help is greatly appreciated.

 

[mrice]

You can do this by linking a further cell to the one that's changing an
then creating a worksheet_change event macro that performs the cop
operation triggered by the change of the second cell