saturdaygig
New Member
- Joined
- Aug 1, 2002
- Messages
- 22
I have a list of projects, and the second column contains a pick list (drawn from a range on sheet 2) of project solution types. These types can be changed during the life of the project.
Each project has a set of milestone and activity start/end dates which are defined by the project type selected in col 2. I want these to be automatically set up when the project type is selected. Right away I can see two ways to do it although I don't know how to code either.
1. Have all possible date headings strung out accross the top row, and have the irrelevant ones grey out when a project type is selected. I guess this can be done by setting up standard grey-out cells on sheet 2 for each type, and some sort of conditional format code.
2. Have a different sheet (or section of one sheet) for each project type
with the headings already defined. Make the project row jump to the right area when the type is selected from the drop down.
3. Any other way you can think of.
Project_Type_date1____date2___date3__date4
1______a___required__required__not___not
2______b___not______required__not____required
3______b___not______required__not____required
4______a___required__required__not____not
5______c___required__not______ not____not
sorry its a bit complicated, I hope I succeeded in explaining the adequately.
Each project has a set of milestone and activity start/end dates which are defined by the project type selected in col 2. I want these to be automatically set up when the project type is selected. Right away I can see two ways to do it although I don't know how to code either.
1. Have all possible date headings strung out accross the top row, and have the irrelevant ones grey out when a project type is selected. I guess this can be done by setting up standard grey-out cells on sheet 2 for each type, and some sort of conditional format code.
2. Have a different sheet (or section of one sheet) for each project type
with the headings already defined. Make the project row jump to the right area when the type is selected from the drop down.
3. Any other way you can think of.
Project_Type_date1____date2___date3__date4
1______a___required__required__not___not
2______b___not______required__not____required
3______b___not______required__not____required
4______a___required__required__not____not
5______c___required__not______ not____not
sorry its a bit complicated, I hope I succeeded in explaining the adequately.
