Hello,
I have 2 resources (TPM & ENG) in these projects. Hours per quarter are different for both these resources (Ref! Columns C,D,E,F) LOE! - I enter R1 & R2 (Columns C & D). Total is calculated. Based on the Total, Project size is calculated. I enter Launce date and based on the launch year and qtr, I want the hours to be populated for respective resources (Columns K - V) K-P columns are ENG hours and R - V are TPM hours that I want in the cells.
so we look at QTR, then PROJECT SIZE and ROLE to pick up the HOURS
Solved by S. D. in 30 mins