Results 1 to 6 of 6

How do I use check boxes to join multiple possible text options into a new worksheet?

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2011
    Location
    Galphanore
    MS-Off Ver
    Both 2007 and 2010 of the whole suite.
    Posts
    4

    How do I use check boxes to join multiple possible text options into a new worksheet?

    What I have right now is a spreadsheet with 8 separate worksheets. Each worksheet has a list of things in it that includes six fields. The first two are check boxes, the remaining four are text. I hope that makes sense. So, what I'm trying to do is create a new worksheet that only contains the things that were checked in the other sheets. So, if someone checks box 1 in row 1 then Text1-Text3 for that row should show up on the new worksheet, and if they check box 2 in row 1 then Text4 for that row should also show up. It shouldn't be possible for them to check something in Check2 without checking the corresponding Check1. I can't figure out how to get it to work though.

    I'm not overly familiar with excel so I haven't actually been able to even figure out how to get A true/false field to "copy", so to speak, data into another table. I've attached a version of what I have using test data. Can any of you give me some advice ether on where to go to learn what to do or how to do what I'm looking to do?
    Attached Files Attached Files
    Last edited by Galphanore; 03-15-2011 at 07:34 PM.

Thread Information

Users Browsing this Thread

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

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