0
Hello!
I would like to know if it is possible to carry out the following:
I have several checkboxes, where each one is linked to the cell in which it is, when selecting the cell of this box and dragging down, copying the formula that contains in the cell and the box itself, the cell link remains the same as in the above box.
It is possible to make the cell link change together by dragging the cell down?
Example:
Cell AG15 has the check box, and the box is linked to this cell, where in the cell contains the following formula:
=SE(AG15=TRUE;1;0)
So when performing cell selection and dragging down the formula changes to the following:
=SE(AG16=TRUE;1;0)
Getting the formula the right way and only the cell link in the check box remains in the AG15 cell but would like it to automatically change to the AG16 cell also does in the formula.
You have to perform the procedure somehow?
fix the primary cells using the $ for example $AG16
– Lucas mutti
Good morning Lucas! Even if I fix the primary cell in case the "AG" column row does not change, when it is copied/dragged (fill handle) the cell containing the check box, the linked cell is maintained.
– Eduardo Memlak