View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default How can I add rows inbetween?

A slight revision to the earlier formula (removed unnecessary part):

In Sheet2,
Put in A1:


=IF(MOD(ROWS($A$1:A1)-1,4)=0,OFFSET(Sheet1!A$1,INT((ROWS($A$1:A1)-1)/4),),""
)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--