Excel Checkboxes

[KevanForbes]

I need to create a long series of checkboxes in which each box is linked to the cell directly to the right of it. When I try to copy and past the checkbox, the link doesn't update. Which means I have to go in manually and change every checkbox link.

Is there any way to expedite this process? Some way to get the cell link to advance automatically? Any help would be appreciated.

Thanks
Kevan