Separating Option Buttons

[jimmeh]

Greetings,

I'm making a matrix for work, and one thing I would like to add to each item are 2 options. We are tracking the most recent occurrence, whether it be internal or at one of our customers. So what I would like to do is, in each row, have two option buttons for "Customer" & "Internal". Only one box should be able to be checked at one time, so I have to use an Option Button instead of a Check Box. The problem I am running into is: I can't separate the option buttons in each row. If I have two option buttons in Cell A1, if I click on one, the other one goes blank, which is good. But if I have two option buttons in Cell A1 and two in Cell A2, clicking on one of the buttons in A2 removes the checked status from the buttons in Cell A1. Is there any way to separate these option buttons so that that buttons in each cell only affect that cell?

Any help would be appreciated.

[eluehmann]

you have to group them using a group box. Put options which are related in teh group box and you will be able to check one in each group box. I hope that is clear.

[jimmeh]

I have tried grouping each set of options. I then input A1 as the Cell Link for the first group, then A2 as the Cell Link for the second group. But when I go back, the Options in A1 are now linked to A2.

Am I doing something wrong?