I wish to copy a column of numbers, a number in every 5th row, from sheet1 to sheet 2 same column but in consecutive rows.

I have tried to write a do loop to do this but I have to have a variable in the adress of a cell (eg R[2]C) has to be R[p]C where p is counter increasing by 5 every cycle in th eloop.


Thanks for any assistance

Bill