+ Reply to Thread
Results 1 to 1 of 1

Using answers to checkboxes and data from a second tab to generate results on a new tab

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    67

    Question Using answers to checkboxes and data from a second tab to generate results on a new tab

    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?

    Thanks!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using results of a VLookup formula in Data Validation to generate a list
    By JessicaJG in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2013, 03:52 PM
  2. [SOLVED] Need help on returning different answers based on different results - Comparing Sales
    By ec4excel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-21-2012, 01:02 PM
  3. Multiple checkboxes to generate filtered extract
    By ash_farooq in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2012, 11:24 PM
  4. Replies: 5
    Last Post: 10-11-2012, 03:06 PM
  5. Help with sorting the results by the top 10 answers
    By lidalik in forum Excel General
    Replies: 2
    Last Post: 09-24-2010, 11:52 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1