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.
Solved by V. D. in 20 mins