To specify a control cell for the current cell
1.
In the target cell spreadsheet in Edit mode, click in the Control Cell Code column for the cell you are editing.
The cell becomes editable, with a drop-down list. Cell codes for any cells designated as control cells (in other words, that have a value of Yes in their Control Cell column) are available to be selected as control cells.
2.
3.
Click Save or Save and Return to save your changes.