Copying every nth Rows in excel -

Copying every nth Rows in excel -

if have 30 rows, example, , want re-create 1st, 2nd , 3rd, skip five, re-create next 3 , skip 5 1 time again , re-create next 3 rows: how can this? far have formula

=offset(sheet1!$a$1,(row()-1)*5,0)

which gets me 1 cell value entire row copied sheet.

any help great! thanks

here hint: row number modulus 8 in (1,2,3) identifies target row numbers. come in in first column, first row , re-create downwards each column: =if(and(mod(row(sheet1!a1),8) > 0,mod(row(sheet1!a1),8) < 4),sheet1!a1,"")

excel excel-vba optimization excel-formula excel-2003