=INDIRECT("C"&ROW()*8)

HTH. Best wishes Harald

"siverfox19482" skrev i melding
...
How do I copy every 8th cell in a column into consecutive cells in another
column. I don't want to have to point to each cell. With a column of
hundreds of cells, I bound to be off on at least one. I want a formula
that
I can enter for the first cell and then copy and paste to the others.