Hi Folks
Is there a formula to look at the month in cell AO6, match that month to the months shown in ColB and then copy the data from the % Attained for each Skill Level to columns AP7 to AX12 Please???
I managed to do this for blocks of adjacent cells but not for selected blocks of cells as can be seen on the sample sheet.
Any help would be really appreciated please.
Kind regards
DezB