Web Applications Asked on November 3, 2021
Can I copy the CheckBox display from a sheet to another.
Image tab ‘a-sheet’ columns B & C where formatted as checkboxes (Menu > Insert > Checkbox)
Can a new
=QUERY('a-sheet'!A1:ZZ999,"SELECT A, B, C",1)
I have found that you can do (Menu > Insert > Checkbox) on an individual result, but not the whole set of =QUERY
results.
There may be many ways to answer this question. Please consider this as just one solution.
Create a filter
Select the "true" values
Copy and Paste the data
Note that only the header and rows containing the "checked" checkboxes are copied.
Create a filter
Select the "true" values
True values
The copied data
Answered by Tedinoz on November 3, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP