Using checkbox answers to populate a new tab displaying data from another tab (macro?)

Hi,

I have a spreadsheet (attached) where the user takes a survey (see "Prioritize" tab) to generate results (see "Results" tab) that use their answers from the "Prioritize" tab plus data from the "Backend" tab to populate the results. This is working perfectly!

Now, the next step:

On the "Checkboxes" tab, I have created 20 demographic categories with checkboxes. The user will check all the boxes that apply to them. These demographic categories are listed in columns L-X in the "Backend" tab. So for example, you can see on the "Backend" tab that cats are an animal associated with the demographic categories of: loves animals, male, female, employed, lives in suburban area, lives in rural area, married, owns pet, likes coffee, and likes Star Trek. So If someone checked any ONE of those demographic categories in the checkboxes, "Cats" would be displayed in their results tab (this NEW RESULTS tab will be the BLUE tab I've labeled "CHECKBOX RESULTS).

So now, look again at the last tab- yellow- labelled "results".

See the data that is displayed there? It is columns A (animal name), B (color), and H-J (other data associated with the animal). That is the SAME data I want to use in the CHECKBOX RESULTS tab.

So for a person of the demographic categories who is associated with "Cat", the data from A2, B2, G2, H2, I2, J2 will be displayed, in a format that looks like the yellow "results" tab.

I hope this description makes sense.

So my question to you is:

What VBA code/macro/or other method can I use to generate this CHECKBOX RESULTS tab that populates the info as described above?

Note: There is a "show results" button in the Prioritize tab - the macro assigned to this could perhaps be modified to work for the checkbox results tab? And I was thinking maybe VLOOKUP or another lookup function would work as part of the macro? (just a thought; any ideas you have are welcomed!!)


Thanks!