In D25 try the below formula and copy across...
=INDEX(9:9,COLUMN(A1)*5+1)

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve