Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Status Report like Microsoft Project
Hello, I am interested in creating a status report for a website that I am working on. I saw an excel spreadsheet that is pretty much exactly what I am trying to do but I don't know how they created it. I want the spreadsheet to have an expandable tree format. For instance, I will list 5 major sections to the website. These sections will be able to expand when you click on the +. Then under them you will see more sections broken down with +, listing all the pages that will be on the site. From that I want to implement a progress dropdown showing the progress of the site from completion, in progree, not posted, etc. This will then relate back to a field back up at the 5 main sections stating the percentage of completion. I can figure out how to do the whole percentatge stuff, but I dont know how to make the sections expandable. Does any one know? Am I being clear with my description? Thanks in advance for your help. -- Saxy46 ------------------------------------------------------------------------ Saxy46's Profile: http://www.excelforum.com/member.php...o&userid=25236 View this thread: http://www.excelforum.com/showthread...hreadid=387259 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Status Report like Microsoft Project
Try taking a look at SubTotals under Data on the main menu. This is the
only native Excel functionality that has this kind of behaviour (without going into controls that is). Saxy46 wrote: Hello, I am interested in creating a status report for a website that I am working on. I saw an excel spreadsheet that is pretty much exactly what I am trying to do but I don't know how they created it. I want the spreadsheet to have an expandable tree format. For instance, I will list 5 major sections to the website. These sections will be able to expand when you click on the +. Then under them you will see more sections broken down with +, listing all the pages that will be on the site. From that I want to implement a progress dropdown showing the progress of the site from completion, in progree, not posted, etc. This will then relate back to a field back up at the 5 main sections stating the percentage of completion. I can figure out how to do the whole percentatge stuff, but I dont know how to make the sections expandable. Does any one know? Am I being clear with my description? Thanks in advance for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Status Report like Microsoft Project
thanks! i'll check it out...I think what I might do is just use the outline grouping function. That can fake what Im trying to do and then just do some formulas for percentages and what not. Thanks! -- Saxy46 ------------------------------------------------------------------------ Saxy46's Profile: http://www.excelforum.com/member.php...o&userid=25236 View this thread: http://www.excelforum.com/showthread...hreadid=387259 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Project Export to Excel | Excel Discussion (Misc queries) | |||
Trying to report the current phase of a project | Excel Discussion (Misc queries) | |||
AutoFilter report in status bar | Excel Discussion (Misc queries) | |||
Does anyone have a good Status Report template for excel? | Excel Discussion (Misc queries) | |||
How do I import data from Microsoft Project 2003 to Excel? | Excel Discussion (Misc queries) |