I am using combo boxes to enter information. Directly under each combo box is
the "Cell Link" cell for that combo box. When I copy the row down, the combo
box copies down with it's Cell Link cell, as expected. However, the new combo
box is still linked to the origional cell, and must be altered manually to
link to the new "Cell Link" cell.
Is there any way to force excel to automatically update the address of the
"Cell Link" to the new (destination) cell?