For copying values in Row 1 to Row 2 and skipping every other value try in A2
and copy across to B2, C2...
=INDIRECT("R1C"&(COLUMN()-1)*2+1,0)

You can change 2 to 3 or 4 to get every third or fourth value.

For columns use for copying values in Col 1 in B1 and copy down
=INDIRECT("R"&(ROW()-1)*2+1&"C1",0)

"hans L" wrote:

I want to copy data from a row (or column) to a new row (or column) but skip
a fixed number of cells between each data point, e.g.
A B C D E F G H I J
Row 1, 10 12 14 10 11 ( five data points in five cells) to be copied to

Row 2, 10 12 14 10 11

In this case data would skip one cell but my need is often for 2,3 or even
four cells.
Any help would be much appreciated.