I am working on project assignment workbook. I have a PROJECT worksheet that define project and task, I will get the data from project managers about the hours per week for the each of the project tasks. So the worksheet structure like below:
Project Name | Task Name | Jan-12 (hr)|Feb-12(hr)|Mar-20(hr) ----------------------------------------------------------------------------------- Proj-A1000 | App Dev |160 |160 | 80 Proj-A1000 | App Test |40 |80 |100 Proj-B1011 | Test |80 |80 | 40 Then I want to have a worksheet to assign a person to the task and then inherit the work hours for the project task. So the TASK ASSIGNMENT worksheet will look like: Resource Name|Project Name|Task Name |Jan-12 (hr)|Feb-12(hr)| Mar-20(hr) ----------------------------------------------------------------------------------------------------------------- Paul |Proj-A1000 | App Dev | 160 | 160 | 80 Alex |Proj-B1011 | Test | 80 | 80 | 40 I want to be able to select value from Project Name and Task Name from PROJECT WORKSHEET when I am on the Project Name and Task Name from TASK ASSIGNMENT worksheet. I can use the list "Data Validation" feature for Excel 2010 for creating a drop down list for for Project Name column. But I don't know how to do that for the Task Name column on the TASK ASSIGNMENT worksheet as the list will have to be based on Project Name selected for the person. I am not a Excel or VBA developer, and I cannot figure out here. Can experts in this group provide some direction? Many thanks, John -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
