Hi,

I have a number of surveys where the answers are input by Y/N Check Boxes.
The Check Boxes are linked into a "Stats" spreadsheet with the True & False
answers. I need to update the survey spreadsheets for the new period which
means that the cell links need to be changed to a new column in the "Stats",
but keeping the same row.

Up to now I have been going into each Check Box and changing the links one
at a time, but it is taking forever (I.e. Changing $C$106 to $D$106). Is
there a way to select/group all (or even some) of the Check Boxes and change
the column link on mass???

Thanks in advance
TC