As you can see in the Image:
STATEMENTS EXECUTED IN THE IMAGE
Statement 1 -> I know cell with value="ACTUAL" is in row 50. So I move to cell A50.
Statements 2-3 -> Because I have only 3 values (Star, Actual, End) I can select Actual cel with pressing ctrl+right twice.
Statement 4 -> I can select only cells between rows 50-58 pressing ctrl+sift+down and copy them.
Statement 5 -> I insert cells moving to the right.
STATEMENTS TO EXECUTE
Statement 6-7 -> Because after first 5 statements i know there are blank cells i can reach the las values column by selecting cell A51 and pressing ctrl+right once.
Statement 8 -> I can select only cells between rows 51-58 pressing ctrl+sift+down.
Statement 9 -> I need to Autofill the blank cells with the formulas on the range i currently have selected but i don't know how.
I hope is clearer now, thank you very much.
Bookmarks