How to use a CHECKBOX to populate another sheet for a summary?
I have a basic grocery list I want to use for my food truck. I made the checkboxes and all I want is for the checkboxes to correlate with a separate sheet and auto populate.
Question marked as
Here's a sample,using the inventory list in your example.
Column C has been added to your Main table to contain an index marking the items that have been checked.
The shorter formula below the tables is entered as shown in cell C2 of the Main table, and filled down to the last row on that table.
The second table, My List, uses INDEX and MATCH to gather the checked items into a compact list, maintaining the order in which they have been entered on the Main table.
The IF statement at the beginning of this formula checks to find if there are more items to be gathered, and places a null string in the cell if all checked items are now included in the list.
If there are more items to list, MATCH returns the index value of the next item, and INDEX returns the name of the item in that indexed row.
Here are copy and pastable versions of the two formulas. The second requires the Main table to be named "Main" when it is pasted into A2 of the My List table, but that name may be changed once the formula is in the table. Numbers will change the "Main" in the formula to match the new name of the table.
Main::C2: IF(A2,MAX(C$1:C1)+1,"")
Fill down to end of column C.
My List::A2: IF(ROW()−1>MAX(Main::C),"",INDEX(Main::B,MATCH(ROW()−1,Main::C,0)))
Fill down to end of column A.
Regards,
Barry