Is there any way to renumber checkboxes on a spreadsheet? I have several
spreadsheets each with a large number of checkboxes which have been added
over a period while the sheet was in development. I now find I need to
duplicate these checkboxes elsewhere on the sheet such that when eg
checkbox1 is checked, checkbox83 is also checked. Unfortunately checkbox 2
does not relate to checkbox 84 etc making it a long-winded process to write
the code. It would be a lot easier I could renumber the original checkboxes
so that 1 relates to 83, 2-84, 3-85 etc.

Alternatively, is there a way for a cell to change from being empty to
containing a tick (or X would do), simply by clicking it?

Many thanks in advance

Ian