I just had a great idea, but I am not sure how to follow through with
it!! Please help.

I have put together a very simple work progress log. Every Friday I
access this log and add or modify the list of new and ongoing projects.
The log follows every individual project from start to finish. Each
project has a status that changes as the project progresses.

Status = Potential Project, Bids Pending, In Progress, Completion
Phase, etc.

As the spreadsheet is setup right now...

A4:A22 Merged and showing the update date
B4:B22 Lists each project name
C4:C22 Lists the status for each project
Columns D through O Lists current details about each project

Originally, I was going to create an entirely new block for each update
period and just duplicate the projects that had no changes and modify
the status and related details for those projects that did change.

Instead, I would like to have a drop down box for each cell in column
C. If I click on "Potential", the details for that project will all
change to reflect the status. If I click "Bids Pending", the details
for that project will all change to reflect that status, and so on. If
the status on a project just became "Construction Phase", then I would
click that status and be able to fill in the blank details.

This trick I found is that every project will have the same status list
but will have different details.

How would I do this? I am trying to keep the spreadsheet from becoming
massive and also only show the pertinent info. I think this is the best
option, if possible!


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=379653