hi there
could someone help me with this problem
I want to search per column in tab Supply & demand as below - for values less than 0
output should be project and role
then use this output as input into Supply tab as below and search each col (week) for match and output name of resource..
is this possible?
Help really needed.....thank you inadvance
Attachment 464734
tab Supply&Demand:
Projects Project Role 18 19
project 1 Architect 0 0
project 1 Business Analyst -0.1 -0.1
project 1 PM 0 0
project 1 Scrum Master 0 0
project 1 SW Engineer 0 0
Attachment 464733
tab Supply:
Loc SPM Resource Project Project Role Historical Data 18
Ireland Joe Blogss project 2 Engineer 1
Ireland a Core Engineer
Ireland b Core Engineer
Ireland c Core Engineer start date 1st august….
Ireland d project 2 Engineer 0
Ireland e Core Engineer
could someone help me with this problem
I want to search per column in tab Supply & demand as below - for values less than 0
output should be project and role
then use this output as input into Supply tab as below and search each col (week) for match and output name of resource..
is this possible?
Help really needed.....thank you inadvance
Attachment 464734
tab Supply&Demand:
Projects Project Role 18 19
project 1 Architect 0 0
project 1 Business Analyst -0.1 -0.1
project 1 PM 0 0
project 1 Scrum Master 0 0
project 1 SW Engineer 0 0
Attachment 464733
tab Supply:
Loc SPM Resource Project Project Role Historical Data 18
Ireland Joe Blogss project 2 Engineer 1
Ireland a Core Engineer
Ireland b Core Engineer
Ireland c Core Engineer start date 1st august….
Ireland d project 2 Engineer 0
Ireland e Core Engineer
