Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creatiing various "what/if" scenarios
I have a file with numerous tabs (potentially up to 50), each representing the financial profile for a particular project. I also have a summary tab within this file where I consolidated all the projects so that I can see the financial picture for my entire portfolio.
Here is my dilemma....I have been asked if I can build in some logic (check boxes possibly on a user form?) so that someone could pull up my file and select the particular projects they would like to see consolidated instead of all the projects. I could easily do this manually by keeping a master file and then deleting the tabs that I do not want in my consolidation but I'm looking for an automated option. Essentially, I am trying to create a file where we could do what/if scenarios based on various combinations of potential projects. I am drawing a blank on the best approach to accomplish this task. Any thoughts would be greatly appreciated. Regards, HJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Poor Man's" Scenarios | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |