Hi
Can you use a checkbox to select multiple cell's data to be copied to a other sheet.
Hi
Can you use a checkbox to select multiple cell's data to be copied to a other sheet.
In theory, yes. In practice, that could stick you with hundreds or even thousands of check boxes which bloat up your workbook and might slow it down.
Consider a data validation drop-down instead with either only a single permissible answer, like "yes" or "copy", which can be deleted, or a binary response, like "Yes"/"No".