Results 1 to 6 of 6

Ultimate Challenge: Generate List from Checkboxes &/or Values

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Miami, FL
    MS-Off Ver
    Excel 2010
    Posts
    4

    Cool Ultimate Challenge: Generate List from Checkboxes &/or Values

    Relatively new to Excel, but I'm confident that this is possible to do:

    I have a Construction Budget that I want to subsequently produce a Payment Schedule in phases.
    I want to be able to check boxes on line items on my Budget tab (according to their phase, including multiple phase selections) that will magically generate a new list for each phase on the Payment tab.
    For line items that have "x" in multiple phases, the output should divide the $ evenly between the multiple phases.
    I also want to be able to specify a specific percentage in the box instead of an "x" (i.e. "50, x, x" -this would give 50% to the phase with 50 and then divide the remaining total evenly).
    The list needs to maintain its numerical order whether boxes are checked or unchecked.

    If that wasn't enough, the lists need to be able to change dynamically, as I check or uncheck boxes, but it still needs to provide a subtotal below the last line.

    The phases could be displayed on individual tabs.

    If you are up to the challenge, I would love your help.
    Thank you for your time, and genius.
    -Tim

    I've included a sample of what it would possibly look like if the Budget page actually did link to the Payment Schedule tab as I dream. I calculated out the first three imaginary phases to hopefully help anyone understand exactly what I'm trying to do.
    Attached Files Attached Files

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