+ Reply to Thread
Results 1 to 6 of 6

creating a database from existing database by user choice

  1. #1
    Registered User
    Join Date
    05-23-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Office for Mac 2011
    Posts
    68

    Talking creating a database from existing database by user choice

    ok so i am building a character creator workbook for a game based around career lists for said game. Sheet one contains the database and sheet two has a mock up showing the option to choose which careers will be in the final database depending on which reference book they belong to. so how do i make this work for real? i'm guessing i need some sort of macro somehow connected to each check box that populates a new list based on whether the box is checked or not? is this correct and if so how would i write this?

    thanx in advance
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: creating a database from existing database by user choice

    I have created a variable list based on the check boxes - using formulas only
    Look at it so far

  3. #3
    Registered User
    Join Date
    05-23-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Office for Mac 2011
    Posts
    68

    Re: creating a database from existing database by user choice

    thanks for the help so far, oh ok so the numbers in sheet one column a and b relate to how the check box is formatted
    Last edited by almostgenius; 05-29-2015 at 12:56 PM.

  4. #4
    Registered User
    Join Date
    05-23-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Office for Mac 2011
    Posts
    68

    Re: creating a database from existing database by user choice

    so i see that clicking the check box in sheet 2 for say A3 (core) puts "true" in P3 and there is Core in Q3 and (core in R3
    what i need to be the outcome of clicking the checkbox is for a list to be created with every career name that has the same page/ref as the button name from the sheet 1 database, does that make sense? so clicking all the check boxes should make a huge list with every career in it and clicking none should make an empty list

  5. #5
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: creating a database from existing database by user choice

    Add all the book names into Sheet2!Column Q - and copy the formula down in Column R

    as you check the boxes - it modifies the cell in front of the book name (column P) to true (that is in the Properties of the check box - right Click - Format Control - Cell Link = Px)

    On Sheet1! expand the range of the formula in Column B to encompass all the book name on Sheet2 (P:R)
    =IFERROR(IF(INDEX(Sheet2!$P$3:$R$5,MATCH(LEFT(Sheet1!$D2,4),Sheet2!$R$3:$R$5,0),1)=TRUE,1,""),"")
    And copy down

    Sheet1!column A sums the list to create the look up data for variable sheet.

    I generally hide the dirty work: Hide Sheet1 - Hide columns Sheet2!:P:R - Hide VaeiableList!A:A

  6. #6
    Registered User
    Join Date
    05-23-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Office for Mac 2011
    Posts
    68

    Re: creating a database from existing database by user choice

    wow very awesome work thanks ill do as above and complete the work for that, thanks a bunch,
    i have something else I'm trying to do with this and i wasn't sure how to do this until i saw how you made this work.
    the idea of what we have so far is to create a list of all the careers the Game Master will allow the players to choose from.
    the idea in this game is that during the course of the game you change careers from time to time, and the way you pick which career you move into next is by the career entries and exits list the book provides( as in sheet 1)
    so i want to add the question (as in the drop down on sheet 2) that asks the GM the question whether he wants to allow either career entries/exits or both for the player to choose from then uses the answer from that question to move to the next stages follows.
    so then I'm going to have a simple question for the player with a drop down list like this:
    Q1: "select starting character:" (drop down goes here) when the player chooses a career name it displays that name in the drop down list, then on the next line asks the Q2: "choose your next career:" (another drop down goes here) this time the drop down list for this question is populated with career names from the "career entries/exits or both" lists that follow the career name chosen in Q1 listed in sheet 1.

    i hope this all makes sense and i really appreciate the help your giving me on this its awesome!!

+ 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. Replies: 2
    Last Post: 10-22-2014, 11:32 PM
  2. [SOLVED] Questionnaire with multiple choice and database
    By GAMU in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-27-2013, 06:47 AM
  3. Creating User Defined Lists from a Larger Database
    By BaileyDXB in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-16-2012, 04:28 AM
  4. Help creating multiple user entry forms into a database
    By jacobkmc in forum Access Tables & Databases
    Replies: 2
    Last Post: 03-12-2012, 12:05 PM
  5. Creating a user interface for editing a database
    By quiggdavid in forum Excel General
    Replies: 0
    Last Post: 04-04-2011, 05:47 AM

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