+ Reply to Thread
Results 1 to 2 of 2

I desperately need to create a dynamic checklist tool

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    1

    I desperately need to create a dynamic checklist tool

    I have been researching this for over a day and I'm finding it very difficult to accomplish a task on my plate! I need to create a tool in Excel, that will allow a user to create a checklist from a series of "sub-checklists" to dynamically populate a final master checklist with only the sub-checklists that they need for their work. There are roughly 10 sub-checklists, each with between 3-15 tasks associated with the sub-checklist title. For example, one is called "Project Initiation" with subtasks, and another is called "Creative Development" with subtasks and my goal is to allow someone to select which sub-checklists, whether they be few, or many, for population in a final customized checklist that can be used to execute a project.

    At present, I have one workbook with three tabs (attached):
    1. Sheet 1, where I've used data validation to allow someone to choose Yes or No in regard to whether or not they need that checklist section
    2. Sheet 2, where all of the checklists are located
    3. Sheet 3, where I've taken images of each sub-checklist seperately because I saw somewhere that I could bring images in relatively easily (no!)

    Ideally, the resulting checklist would be intuitive to allow for people who skip sub-checklists they don't need to not have a gaping hole in their checklist for where that content would have been, had they said "Yes" to needing the tasks populated. But, this adds more complexity!!!

    Can this be done in Excel? I don't know VBA, but I can learn it with some direction - I just have no idea of what functions to use because there are 1,000 ways to do things and with all of the different nuances, I'm lost. If I'm crazy, and should really know more to be able to do this myself, let me know and I will see if I can bribe a developer....though this is incredibly unlikely so any/all help that anyone can provide will be GREATLY appreciated!

    Thank you all!!!!
    Carrie

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613

    Re: I desperately need to create a dynamic checklist tool

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


    ------------------------------------
    This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

    Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.

    Have you started any work on this project yet?
    How far did you get?
    Where are you stuck?

    We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.
    Ben Van Johnson

+ Reply to Thread

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