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.
Bookmarks