Snasui Excel Forum • insert a row after line 4

Page 1 of 1

insert a row after line 4

Posted: Sun Nov 21, 2021 8:25 pm

by sna

Hi Dear,
I need a formula or VBA to insert a row after line 4 in a range.
I also attached a sample and output

Thanks

Re: insert a row after line 4

Posted: Sun Nov 21, 2021 9:39 pm

by snasui

The example formula in C2 is:

=IFERROR(IF(MOD(ROWS(C$2:C2),5)=0,"",INDEX(A$2:A$17,ROWS(C$2:C2)-INT((ROWS(E$2:E2)-1)/5))),"")

Enter and copy down.

Re: insert a row after line 4

Posted: Mon Nov 22, 2021 11:00 am

by sna

Thank you