How do I copy multiple rows to another sheet based on selection with checkboxes in Excel?

Question

This is a screen clip of 2 sheets in Excel 2013. What I am trying to do is that if the checkbox corresponding with the row is checked, the text in the row shows up in the second sheet. There will be around 75 rows of text with checkboxes. Some number of these will be checked, and for each one checked, the text should show up on the second sheet (with the displayed rows contiguous; all of the text cells for the row copied but not the checkbox).

I have gotten as far as inserting the checkbox, assigning it to a column to show true/false that I will hide later, and trying to use a VLOOKUP. The problem is it just outputs the first value checked. What I need help with is making this work for multiple checkboxes. When I input it with multiple IF functions, it only shows the output for the first checked box and nothing past it.

I have tried formulas such as:

=VLOOKUP(TRUE,TEKS!$A$2:$K$77,4)     or 
=IF(VLOOKUP(TRUE,TEKS!$A$2:$K$77,4)=A1,VLOOKUP(TRUE,OFFSET(TEKS!$A$2:$K$77, 1, 0),4))

These I know do not work, but they are my best attempts. I figure that if I am able to get the cells from column D of the first sheet, I can get the other columns with an if statement.

Answer 1

Try to use a hidden row/column where you evaluate the individual "X"s and if "true" place a text you like to see for each. Then on the result cell, you just combine the output:

Row example:

=A1 & B1 & C1 ...

-or-
Column example:

=A1 & A2 & A3 ...

UPDATE (to address comment):

The "IF" function has three parameters, two of which are optional

=IF(criteria [, true statement][, false statement])

If you do not include any of the optional statements it will return the words TRUE or FALSE depending on the outcome.

So, if you like to have a specific text returned, you need to put it in surrounded by quotation marks. If you want to have nothing returned (e.g. when the criteria is not met), you can use an empty string:

=(B1="ABC", "X", "")

This will return "X" whenever "B1" is filled with the text "ABC" (true statement). For any other value in cell "B1", it will return an empty string (false statement).

If you pick it up with the row or column example, it will return exactly what is in there.

Let's say "A1" is true, "B1" is not, and "C1" is again true. Using "ABC" for "A1", "DEF" for "B1" and "GHI" for "C1", it will return "ABCGHI".