checkboxes and cell-link references
 

Is there a quick way to copy a checkbox and have the cell-link reference not
remain constant? For example, I have a checkbox in cell A1 with the
cell-link as B1. If I copy the checkbox to A2, would like the cell-link to
be B2 (not B1.)

I have a client list that is grouped by company and sorted alphabetically
(in 4 columns) and have a check box nexxt to each person's name (500+).
Everytime I need to update the list or create a new one it is extremely time
consuming to update the property for each box.