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.