How to create checkbox in Calc that linked to cell in its sheet

English
,
#1

In Sheet1 I create checkbox and link it to cell in same sheet.
When I copy Sheet1 and create Sheet2, checkbox in Sheet2 linked to cell in Sheet1.

Is it possible to create link to current sheet, so when sheet being copied, then links in all checkboxes would be linked to new sheet?

Thanks.

#2

You can use lookup function for the same.

#3

Can you please explain how to use lookup with checkboxes?

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.