If only D25 is selected, as is the case when the file attached to post #1 is first opened, then only D25 will be copied down to D26 etc. On the other hand if D18:D25 are selected and the fill handle is pulled down cells D26:D33 will fill in the order described in post #1.
Let me know if you have any questions.