List with check boxes of varying lenght

[greywolfnsl]

Hello,

I have a list of recipes, say recipe 1-10 in the B column (and these recipes have hyperlinks to other sheets where the recipe actually are, more on this in a minute). I have check boxes that are linked to their corresponding cells horizontally. What I am trying to do is create a list that will only display the recipes that have a check mark next to them. So if I have only recipes 1,6,and 10 checked I want the list to only have those 3 in the list and with no rows in between them because I'm eventually going to have as many as a hundred or more recipes in the list.

Also, when this list is made, will it copy the hyperlink to the actual recipe that is on another sheet

Rough example: CB=unchecked checkbox, (CB)=checked checkbox

Table List
(CB) Recipe 1
CB Recipe 2
CB Recipe 3
CB Recipe 4
CB Recipe 5
(CB) Recipe 6
CB Recipe 7
CB Recipe 8
CB Recipe 9
(CB) Recipe 10

Table Output:

Recipe 1
Recipe 6
Recipe 10

Thank you for any help. I applicate it.