Copying cells

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

Is there a way I can copy cells from a sheet by scipping
every 5 rows? I have quarterly numbers in the source
sheet, but only want to copy the annual cells. In my new
sheet I have tried to block two cells with a 4 rows dif.
and copy them downwards, but it still returns every line
from the source sheet and not just everey 5th line, which
I am interested in.

Thanks,
Stephen
 
Hi Stephen
if you want to link them with formulas you may use the following
formula in A1
=OFFSET('old_sheet'!$A$1,(ROW()-1)*5,0)
and copy down. This will get you A1, A6, A11, A16,... from the existing
sheet
 
Back
Top