Send your file with a complete explanation and examples.
Don Guillett
SalesAid Software
dguillett1 @gmail.com
-----Original Message-----
From: John
Sent: Sunday, January 15, 2012 10:04 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ how to create a list based on query or some kind
of compound list
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
--
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
