I'm working on the attached spreadsheet and trying to figure out how I can perform the following operation:
I want to assign J2,J3:AH2,AH3 to reflect the values in F4:F9 and G4:G9 according to the variable in D2.
For example, if the value is D2 is "4", I want the value in F4 reflected in J2:M2. Then, I want the value in F5 reflected in O2:R2, F6 in T2:W2 and so on.
If the value in D2 is "6", I want the value in F4 in J2:M2, O2, P2 (skipping N2) and the value in F5 in Q2, R2 (skipping S2), T2:W2 etc....
I don't even know what this would be called and as I said I have almost no experience in excel. Any help will be greatly appreciated.
Thanks!
Bookmarks